Execute Ad-hoc SQL

Required role: write or higher.

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

The evaluation is not incremental.

Path Parameters
pipeline_name string — REQUIRED Unique pipeline name

Query Parameters
sql string — REQUIRED SQL query to execute
format string — REQUIRED Possible values: [text, json, parquet, arrow_ipc, hash] URL-encoded format argument to the /query endpoint. Input data format, e.g., 'text', 'json' or 'parquet'

Responses
200 Ad-hoc SQL query result Schema — OPTIONAL string
400 Invalid SQL query Schema — OPTIONAL details Detailed error metadata. The contents of this field is determined by error_code. error_code string Error code is a string that specifies this error type. message string Human-readable error message.
404 Pipeline with that name does not exist Schema — OPTIONAL details Detailed error metadata. The contents of this field is determined by error_code. error_code string Error code is a string that specifies this error type. message string Human-readable error message.
500 Schema — OPTIONAL details Detailed error metadata. The contents of this field is determined by error_code. error_code string Error code is a string that specifies this error type. message string Human-readable error message.
503 Schema — OPTIONAL details Detailed error metadata. The contents of this field is determined by error_code. error_code string Error code is a string that specifies this error type. message string Human-readable error message.