Get SQL Query Status

Use the GET /api/v3/query/{queryId} endpoint of the Data 360 Query API to check the execution status of a submitted query. Poll this endpoint after submitting an ASYNC or timed-out ADAPTIVE query to determine when results are ready to retrieve. The response includes completion status, row count, chunk count, and execution statistics.

Syntax

  • HTTP Method: GET
  • Format: REST
  • URI: /api/v3/query/{queryId}

Path Parameters

Parameter Type Description
queryId string Required. The unique identifier of the query. Returned in the x-hyperdb-status response header from POST /api/v3/query. Example: MTAuMjcuMTgxLjE0OTo3NDg0_1cfc8d35.

Query Parameters

Parameter Type Description
waitTimeMs integer (Optional) How long to wait for a status change before returning, in milliseconds. Default and maximum: 10000 (10 seconds).

Request Headers

Header Value
Authorization Bearer {accessToken}

Response Structure

Field Description
queryId Unique identifier for the query
completionStatus Query state: RUNNING (still executing), RESULTS_PRODUCED (complete but not yet durably stored), or FINISHED (persisted to storage, results retrievable for the full expiration window)
chunkCount Total number of result chunks available
rowCount Total rows in the result set
progress Completion fraction from 0 to 1
expirationTime ISO 8601 timestamp when results expire
executionStats Object containing wallClockTime and rowsProcessed

Examples

This example shows a status poll request and response.

Request

GET https://{dne_cdpInstanceUrl}/api/v3/query/MTAuMjcuMTgxLjE0OTo3NDg0_1cfc8d35-464c-9185-1f41-3eb638a71f7a
Authorization: Bearer {accessToken}

Response

{
  "queryId": "MTAuMjcuMTgxLjE0OTo3NDg0_1cfc8d35-464c-9185-1f41-3eb638a71f7a",
  "completionStatus": "RESULTS_PRODUCED",
  "chunkCount": 1,
  "rowCount": 10,
  "progress": 1,
  "expirationTime": "2025-09-26T10:55:07.438Z",
  "executionStats": {
    "wallClockTime": 0.204560264,
    "rowsProcessed": 10
  }
}

Related Resources