Skip to Content

Execute Ad-hoc SQL

GET/v0/pipelines/{pipeline_name}/query
Authentication
Parameters

Execute ad-hoc SQL in a running or paused pipeline.

The evaluation is not incremental.

Authentication

SchemeTypeDetails
JSON web token (JWT) or API keyBearer tokenAuthorization header · Use a JWT token obtained via an OAuth2/OIDC login workflow or an API key obtained via the `/v0/api-keys` endpoint.

Parameters

Path parameters

NameTypeRequiredDescription
pipeline_namestringYesUnique pipeline name

Query parameters

NameTypeRequiredDescription
sqlstringYesSQL query to execute
formatAdHocResultFormatYesInput data format, e.g., 'text', 'json' or 'parquet'

Response

text/plain
Ad-hoc SQL query result
  • string (binary)
Request
curl -X GET '/v0/pipelines/{pipeline_name}/query?sql=%3Csql%3E&format=%3Cformat%3E' \
  -H 'Authorization: Bearer YOUR_TOKEN'
Response
Ad-hoc SQL query result
"string"