Execute Raw Query
POST/api/v1/queries/raw
Execute a raw query against a registered datasource adapter.
This is the lower-level query path -- for ad-hoc queries against
datasource adapters rather than parameterized views. The SQL runs as the
engine's own ClickHouse user, so it requires raw_query:execute, which no
built-in role but admin holds, and ClickHouse runs it read-only.
It returns at most options.limit rows, or query_views.default_limit,
capped at query_views.max_limit, with has_more set when the query had
more. The datasource stops reading past the cap.
Request
Responses
- 200
- 401
- 403
- 422
- default
Successful Response
No valid session: the credentials are missing, invalid or expired, or the account behind them is disabled or blocked
Refused: the session lacks the action this route checks, or its account must replace an issued password first. A SCIM route answers a refused action in the RFC 7644 error envelope
Validation Error
Problem details (RFC 9457)