Get Execution Status

Check the status of an execution request

You must pass the execution_id obtained from making an execute query POST request.

Returns the status of a query execution along with relevant metadata of the results if the execution is completed.

cURL

curl -X GET "https://api.dune.com/api/v1/execution/{{execution_id}}/status" -H x-dune-api-key:{{api_key}}

Headers

X-DUNE-API-KEY

string

required

API Key for the service

Path Parameters

execution_id

string

required

unique identifier of the execution

Query Parameters

api_key

string

API Key for the service, alternative to using the HTTP header X-DUNE-API-KEY.

Response

200

application/json

OK

execution_id

string

required

Unique identifier for the execution of the query and corresponding result.

Example:

"01HKZSJAW6N2MFVCBHA3R8S64X"

query_id

integer

required

Unique identifier of the query.

Example:

1252207

state

string

required

The state of the query execution.

Example:

"QUERY_STATE_COMPLETED"

submitted_at

string

required

Timestamp of when the query was submitted.

Example:

"2024-01-12T21:34:37.447476Z"

is_execution_finished

boolean

Whether the state of the query execution is terminal. This can be used for polling purposes.

Example:

true

expires_at

string

Timestamp of when the query result expires.

Example:

"2024-04-11T21:34:55.737082Z"

execution_started_at

string

Timestamp of when the query execution started.

Example:

"2024-01-12T21:34:37.464387517Z"

execution_ended_at

string

Timestamp of when the query execution ended.

Example:

"2024-01-12T21:34:55.737081299Z"

cancelled_at

string

Timestamp of when the query execution was cancelled, if applicable.

Example:

"2023-04-08T12:27:15.749154Z"

result_metadata

object

Metadata about the execution of the query, including details like column names, row counts, and execution times.

Show child attributes

result_metadata.column_names

any[]

Names of the columns in the result set.

Example:

[
  "Rank",
  "project",
  "Total Volume",
  "7 Days Volume",
  "24 Hours Volume"
]

result_metadata.result_set_bytes

integer

Number of bytes in the result set for the current page of results.

Example:

1541

result_metadata.row_count

integer

Number of rows in the result set for the current page of results.

Example:

28

result_metadata.total_result_set_bytes

integer

Total number of bytes in the result set. This doesn't include the json representation overhead.

Example:

1541

result_metadata.total_row_count

integer

Total number of rows in the result set.

Example:

28

result_metadata.datapoint_count

integer

The count of datapoints used for billing/pricing, based on the result set.

Example:

140

result_metadata.pending_time_millis

integer

Time in milliseconds that the query was pending before execution.

Example:

16

result_metadata.execution_time_millis

integer

Time in milliseconds that the query took to execute.

Example:

18272

Example:

{
  "column_names": [
    "Rank",
    "project",
    "Total Volume",
    "7 Days Volume",
    "24 Hours Volume"
  ],
  "result_set_bytes": 280,
  "row_count": 5,
  "total_result_set_bytes": 4400,
  "total_row_count": 400,
  "datapoint_count": 25,
  "pending_time_millis": 16,
  "execution_time_millis": 18272
}