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 |
| 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