post
Last updated
Was this helpful?
Last updated
Was this helpful?
This endpoint is used for executing SQL queries against data stored in Redivis.
API queries are designed for interactive exploration of data on Redivis, and should not be used for ETL operations or real-time analysis of very large tables. All users are subject to a moving 24-hour computational limit for interactive queries of 100,000 compute slot-seconds. To avoid exceeding this limit, make sure to first transform your data on Redivis. Each user is also limited to 5 simultaneous query jobs.
Provide a JSON object with information about the dataset.
query
string
Required. The SQL query, following the standard Redivis SQL syntax. All table references in the query must be fully qualified, unless a defaultWorkflow
or defaultDataset
is provided (see below).
The query cannot be more than 256k characters.
defaultWorkflow
string
Optional. Cannot be present if defaultDataset
is specified.
defaultDataset
string
Optional. Cannot be present if defaultWorkflow
is specified.
Data access to all tables referenced by the query is required. If a table's data is not public, your access token must have one of the following scopes:
data.data
data.edit
Should be specified as the fully qualified . Any tables in your query that aren't fully qualified will be assumed to be a part of this workflow.
Should be specified as the fully qualified . Any tables in your query that aren't fully qualified will be assumed to be a part of this dataset.
Returns the JSON-encoded "get" representation of a .