Run SQL as one of the warehouse's users
Synchronous: the console's query editor. The user name and password are typed by the caller and never stored. At most 10,000 rows or 16 MiB (truncated), 300 seconds. 429 too_many_queries past 20 running; 503 while no node serves. With an Idempotency-Key the statement runs at most once: a retry replays that it ran (without its rows), and 409 query_outcome_unknown when it was sent but its answer never came back.
https://warehouse-api.ezghcloud.com/v1/organizations/{orgId}/projects/{projectId}/warehouses/{warehouse}/queryAuthorization
Path parameters
Header parameters
Request bodyJSONrequired
Returns
200
The result.
400
invalid_request (with issues), invalid_cursor, or the endpoint's own 400 codes.
403
access_denied: the caller's policies don't allow the action; forbidden_origin: a cookie-authenticated write from an origin that isn't allowed; spend_limit_reached.
404
not_found: unknown, malformed, or in an organization the caller isn't in.
409
quota_exceeded (an allocation quota, with quota), idempotency_conflict, idempotency_in_progress (with Retry-After), organization_deletion_pending, operation_in_progress, or the endpoint's own 409 codes.
413
payload_too_large: the body is over the endpoint's limit (1 MiB unless it says otherwise).
429
too_many_requests, with Retry-After; or quota_exceeded (a rate, usage or concurrency quota, with quota), never with Retry-After.
500
internal_error: a bug; the details are in the logs, under the request ID.