post

Overview
This endpoint is used for executing SQL queries against data stored in Redivis.
HTTP Request
POST /queries
This endpoint extends the general API structure​
Request body
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.
Authorization
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
​Learn more about authorization.​
Response body
Returns the JSON-encoded "get" representation of a query resource.

get

listRows

Last modified 1yr ago

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.