A dataset consisting of the results from a SQL query

A dataset consisting of the results from a SQL query

sql_record_spec(names, types)

sql_dataset(driver_name, data_source_name, query, record_spec)

sqlite_dataset(filename, query, record_spec)

Arguments

names

Names of columns returned from the query

types

List of tf$DType objects (e.g. tf$int32, tf$double, tf$string) representing the types of the columns returned by the query.

driver_name

String containing the database type. Currently, the only supported value is 'sqlite'.

data_source_name

String containing a connection string to connect to the database.

query

String containing the SQL query to execute.

record_spec

Names and types of database columns

filename

Filename for the database

Value

A dataset