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.
Deprecated. Please use to_[geo]pandas_dataframe instead.
(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 workflow. 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 dict 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.
([max_results, *, variables, ...])
Deprecated. Return a list of named tuples referencing the rows of the query results. Use .to_pydict() instead.
([...])
Return an iterator that yields , for processing the query results in a memory-efficient streaming manner.
([max_results, ...])
Return a for the query results. Data is backed by disk, allowing for larger-than-memory analysis.
([max_results, ...])
Return a with the query results.
([max_results, ...])
([...])
Return a . For working with query results that contain a geography variable.
([max_results, ...])
Return a . Data is backed by disk, allowing for larger-than-memory analysis.
([max_results, ...])
Return a with the query results.
([max_results])
Return a . Data is backed by disk, allowing for larger-than-memory analysis.