Get SQL Query Chunks
Use the GET /api/v3/query/{queryId}/chunks/{chunkId} endpoint of the Data 360 Query API to retrieve a specific result chunk from a completed query. Use the chunkCount field from the query status response to determine the available chunk IDs. Results are streamed and available in JSON or Apache Arrow format.
- HTTP Method: GET
- Format: REST
- URI:
/api/v3/query/{queryId}/chunks/{chunkId}
| Parameter | Type | Description |
|---|---|---|
queryId | string | Required. The unique identifier of the query returned from POST /api/v3/query. Example: MTAuMjcuMTgxLjE0OTo3NDg0_1cfc8d35. |
chunkId | integer | Required. The chunk index to retrieve. The index starts at 0. Use chunkCount from the query status response to determine the total number of available chunks. |
| Parameter | Required | Type | Description |
|---|---|---|---|
omitSchema | No | boolean | true to omit schema metadata from the response. Default false. |
| Header | Value |
|---|---|
Authorization | Bearer {accessToken} |
Accept | application/json or application/vnd.apache.arrow.stream |
Results are streamed using Transfer-Encoding: chunked.
| Field | Description |
|---|---|
metadata | Object containing column schema. Not included when omitSchema=true. |
data | Array of result rows, where each row is an array of values ordered by the metadata.columns schema. |
returnedRows | Number of rows returned in this chunk. Arrow responses omit this field. |
Set Accept: application/vnd.apache.arrow.stream to receive the chunk as a binary Arrow IPC stream instead of JSON. Arrow is recommended for large chunks.
This example shows a chunk retrieval request and response.