post
This endpoint is used for executing SQL queries against data stored in Redivis.
POST /queries
Provide a JSON object with information about the dataset.
Property name | Type | Description |
query | string | Required. The SQL query, following the standard Redivis SQL syntax. All table references in the query must be fully qualified, unless a defaultProject or defaultDataset is provided (see below). The query cannot be more than 256k characters. |
defaultProject | string | Optional. Cannot be present if defaultDataset is specified. Should be specified as the fully qualified project reference. Any tables in your query that aren't fully qualified will be assumed to be a part of this project. |
defaultDataset | string | Optional. Cannot be present if defaultProject is specified. Should be specified as the fully qualified dataset reference. Any tables in your query that aren't fully qualified will be assumed to be a part of this dataset. |
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
Last modified 1yr ago