Get Query Result
Retrieve a stored query run by its ID, including its result rows. Results larger than the inline storage cap are replayed truncated (truncated: true).
Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Path Parameters
The ID of the query result to retrieve
Response
Query result details
Query result ID
Object type identifier
query_result Current status of the query. Synchronous queries return 'completed' or 'failed'.
completed, failed, in_progress, cancelled Unix timestamp of when the query was created
Collection IDs the query ran over
The effective SQL that was executed (echoes the request's sql)
Result columns in select order
Result rows as objects keyed by column name
Number of rows returned
Whether the result was truncated by max_rows or the stored-result size cap
True when the query was only validated/compiled (dry_run request): columns holds the output schema and rows is null.
Dataset and timing usage for the run
Error details if the query failed
The result format ('csv'/'jsonl' for background exports)
json, csv, jsonl Signed URL to download a completed background export. Valid for 24 hours and not refreshed on read (re-run the export if it expires); null for synchronous runs and until a background export completes
Unix timestamp (ms) when download_url expires
Compressed size of a completed background export, in bytes