Skip to main content
You must pass the execution_id obtained from making an execute query POST request. Result returns the status, metadata, and query results (in CSV) from a query execution.
  • Results data from an execution are currently stored for 90 days. This is visible on the API response on the “expires_at” field in the execution status and results body.
  • There is currently a 1GB limit in how much data a single API result call can return, but there is a chance we reduce this overall or based on varying paid plan types.
  • To paginate query results, please visit the pagination page to get more info.
If you are using the Python SDK, you can directly executes and fetches result in one function call, like below:
Python 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")
    )



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