Query bounded rows from a staged statistical dataset
query_datasetReturn only bounded selected rows using literal equality filters.
There is no SQL, shell, filesystem, network-function, extension, or mutation surface. A safe default limit applies when limit is omitted.
Page with offset: rows come back in the dataset's stored order, and
next_offset in the response is the absolute offset to pass as the next
call's offset. Stored order is the provider's order, not necessarily
chronological; filter TIME_PERIOD with where or sort client-side.
next_offset is null when there is no next page to ask for, which is not
the same as having received everything. Check truncated too: null with
truncated: false means the matches are exhausted; null with
truncated: true means rows remain that this byte budget cannot reach,
and min_bytes_required says what budget would.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Optional max rows to return (a safe default applies when omitted) | |
| where | No | Optional {column: value | [values]} literal-equality row filters | |
| offset | No | Optional absolute zero-based row offset; pass back next_offset | |
| select | No | Optional list of columns to return (defaults to all columns) | |
| max_bytes | No | Optional smaller byte budget for this response; it can only lower the server ceiling, never raise it | |
| dataset_id | Yes | Id returned by stage_url | |
| response_format | No | How the rows are sent. "auto" (default) means no preference and lets the server decide; "text" sends them as CSV only — in the text content, and in structuredContent as a "csv" string in place of typed rows. "structured" sends typed rows only, "both" the CSV and the typed rows. If you got a summary but no rows, call again with response_format="text". | auto |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | No | ||
| rows | No | ||
| columns | No | ||
| truncated | Yes | ||
| next_offset | Yes | ||
| limit_source | Yes | ||
| matched_rows | Yes | ||
| applied_limit | Yes | ||
| returned_rows | Yes | ||
| max_bytes_ceiling | No | ||
| min_bytes_required | No |