Run Sql Query

Validate or execute an SQL SELECT statement against datasets.

  • sql (str): Required. A SELECT statement where table names are dataset IDs.
  • validate_only (bool): Optional. When True, validate without executing.
Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Validates or runs a SQL SELECT statement against datasets. Table names in the statement are dataset IDs.

When to use it

Use it to read records from one or more datasets. Set validate_only to true to check a statement without running it, and thumbnail_size to embed image columns as base64 thumbnails.

Required parameters

  • sql (body): a SELECT SQL query to validate or execute.

Optional body fields: validate_only, thumbnail_size.

Response

A successful call returns 200 OK with valid, whether the statement is valid; error; and data, the result rows.

Related: Query datasets in natural language, Get a dataset, Get an image from a dataset

Body Params
string
required
length ≥ 1

A SELECT SQL query to validate or execute

boolean
Defaults to false

When True, validate the SQL without executing it

enum

Fetch and base64-embed image columns at this thumbnail size

Responses

400

Bad Request

422

Unprocessable Entity

Language
Credentials
OAuth2
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json