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.
Pricing
This endpoint has no charge and does not consume credits.Execution States
Once an execution is triggered, it can be in one of the following states: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 theallow_partial_resultsflag totruein the API request to fetch the result.
Error Response Fields
When a query execution fails (QUERY_STATE_FAILED), the response includes an error object with the following fields:
- type (string): Error type classification (e.g.,
FAILED_TYPE_EXECUTION_FAILED) - message (string): Detailed error message explaining what went wrong, including line and column information
- metadata (object): Additional error context
- line (integer): Line number where the error occurred
- column (integer): Column position where the error occurred
Headers
API Key for the service
Path Parameters
Execution ID
Query Parameters
Alternative to using the X-Dune-Api-Key header
Response
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"