Get Execution Result

Given an execution ID, returns result of a an execution request

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

Result returns the status, metadata, and query results (in JSON) from a query execution.

• Read more on Filtering, Sorting, and Sampling to learn more about flexibly grabbing query results.
• Read more on Pagination to get the most out of the API and handle large results.

• Results data from an execution are stored for 90 days. This is visible on the API response on the “expires_at” field in the execution status and results body.
• Dune internally has a maximum query result size limit (which currently is 8GB, but subject to increase in the future). If your query yields more than 8GB of data, the result will be truncated in storage. In such cases, pulling the result data (using pagination) but without specifying allow_partial_results set to true will trigger an error message: “error”: “Partial Result, please request with ‘allows_partial_results=true’”. If you wish to retrieve partial results, you can pass the parameter allow_partial_results=true. But please make sure you indeed want to fetch the truncated result.

Execute query and get result in one call

If you are using the Python SDK or community Typescript SDK, you can directly execute and fetch a result in one function call, like below:

• Python SDK
• Typescript SDK

import dotenv, os, json
from dune_client.types import QueryParameter
from dune_client.client import DuneClient
from dune_client.query import QueryBase

# change the current working directory where .env file lives
os.chdir("/Users/abc/local-Workspace/python-notebook-examples")
# load .env file
dotenv.load_dotenv(".env")
# setup Dune Python client
dune = DuneClient.from_env()

Use run_query to get result in JSON, run_query_csv to get result in CSV format, and run_query_dataframe to get result in Pandas dataframe

result = dune.run_query(
    query=query # pass in query to run 
    , performance = 'large' # optionally define which tier to run the execution on (default is "medium")
    )

Headers

X-DUNE-API-KEY

string

required

API Key for accessing this service

Path Parameters

execution_id

string

required

unique identifier of the execution

Query Parameters

ignore_max_datapoints_per_request

boolean

There is a default 250,000 datapoints limit to make sure you don't accidentally spend all your credits in one call. To ignore the max limit, you can add ignore_max_datapoints_per_request=true

allow_partial_results

boolean

Sometimes request results can be too large to return. By default allow_partial_results is set to false and a failed state is returned.

Response

200

application/json

OK

execution_id

string

required

Unique identifier for the execution of the query.

query_id

integer

required

Unique identifier of the query.

state

string

required

The state of the query execution.

submitted_at

string

required

Timestamp of when the query was submitted.

expires_at

string

Timestamp of when the query result expires.

execution_started_at

string

Timestamp of when the query execution started.

execution_ended_at

string

Timestamp of when the query execution ended.

cancelled_at

string

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

result

object

Show child attributes

result.rows

object[]

The rows of data returned by the query.

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

string[]

Names of the columns in the result set.

result.metadata.result_set_bytes

integer

Total number of bytes in the result set.

result.metadata.total_row_count

integer

Total number of rows in the result set.

result.metadata.datapoint_count

integer

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

result.metadata.pending_time_millis

integer

Time in milliseconds that the query was pending before execution.

result.metadata.execution_time_millis

integer

Time in milliseconds that the query took to execute.

error

object

Show child attributes

error.type

string

The type of error that occurred.

error.message

string

A descriptive message about the error.

error.metadata

object

Show child attributes

error.metadata.line

integer

The line number at which the syntax error occurred.

error.metadata.column

integer

The column number at which the syntax error occurred.