Check the status of an execution request
execution_id obtained from making an execute query or execute SQL POST request.
Returns the status of a query execution along with relevant metadata of the results if the execution is completed. This endpoint now includes detailed error information when a query fails, eliminating the need to call the results endpoint just to get error details.
QUERY_STATE_PENDING: The query execution is waiting for an execution slot.QUERY_STATE_EXECUTING: The query is currently executing.QUERY_STATE_FAILED: The query execution failed. This is a terminal state. The response will include detailed error information.QUERY_STATE_COMPLETED: The query execution completed successfully. You can retrieve the query result for this execution_id.QUERY_STATE_CANCELED: The query execution was canceled by the user.QUERY_STATE_EXPIRED: The query execution expired, and the result is no longer available.QUERY_STATE_COMPLETED_PARTIAL: The query execution was successful, but the result was truncated because it was too large. To receive the truncated result, set the allow_partial_results flag to true in the API request to fetch the result.QUERY_STATE_FAILED), the response includes an error object with the following fields:
FAILED_TYPE_EXECUTION_FAILED)API Key for the service
Execution ID
Alternative to using the X-Dune-Api-Key header
OK
Timestamp of when the query execution was cancelled, if applicable.
"2024-12-20T11:04:18.724658237Z"
In case the execution had an error, this object will contain the error details
Cost of the execution
Timestamp of when the query execution ended.
"2024-12-20T11:04:18.724658237Z"
Unique identifier for the execution of the query and corresponding result.
"01HKZJ2683PHF9Q9PHHQ8FW4Q1"
Timestamp of when the query execution started.
"2024-12-20T11:04:18.724658237Z"
Timestamp of when the query result expires.
"2024-12-20T11:04:18.724658237Z"
Whether the state of the query execution is terminal. This can be used for polling purposes.
true
Number of interactive executions this customer can have running in parallel
3
Total number of interactive executions this user has submitted which are still in progress only set to > 0 if the user has reached the limit of concurrent interactive executions
5
Unique identifier of the query.
1234
1
Metadata about the execution of the query, including details like column names, row counts, and execution times.
The state of the query execution.
"QUERY_STATE_COMPLETED"
Timestamp of when the query was submitted.
"2024-12-20T11:04:18.724658237Z"