Query
Last updated
Was this helpful?
Last updated
Was this helpful?
Used to execute a SQL query against table(s) in Redivis, using the , and read out the results.
properties
Download all files represented by a file_id variable in the query results to a local directory.
Fetch query metadata. Once called, the properties
attribute on the query will be fully populated.
(query_string)
Execute a SQL query within the (either a dataset or workflow).
In a Redivis notebook, the default scope will always be the notebook's workflow, and the notebook's source table can be referenced via the _source_
identifier.
If no default scope is specified, all tables in the query must be fully qualified. Consult the documentation to learn more.
(query_string)
Execute a SQL query scoped to a specific . Tables referenced by the query do not need to be fully qualified, since the table lookup is already scoped to the dataset. Consult the documentation to learn more.
(query_string)
Execute a SQL query scoped to a specific . Tables referenced by the query do not need to be fully qualified, since the table lookup is already scoped to the dataset. Consult the documentation to learn more.
A named list containing the . This will always be populated after the query has been created, and can be refreshed by calling query.get()
([path, *, overwrite, ...])
()
([max_results, ...])
Return a list of instances for query results containing a file_id variable.
([...])
Returns a reader that mimics the , which can then be consumed to process batches of rows in a streaming fashion.
([max_results, ...])
Return an for the table. Data is backed by disk, allowing for larger-than-memory analysis.
([max_results, ...])
Return an with the table's data. This is the highest-performance option for loading data in-memory.
([max_results, ...])
Return a with the table's data.
([max_results, ...])
Return a with the table's data.
([max_results, variables, ...])
Return a with the table's data.
([max_results, ...])
Return a with a table's data. Used for tables that contain a geography variable.