Get Latest Query Result in CSV

Given a query ID, returns the latest executed result of a query on Dune as CSV

You must pass parameter query_id.

Returns the latest execution id and results (in CSV) of that latest run, regardless of the job id/run or if it is run in the app or the api.

The query specified must either be public or a query you have ownership of (you or a team you belong to have ownership).

• This endpoint does NOT trigger an execution but does consume credits through datapoints.
• 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.

• 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, 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")
    )

Headers

X-DUNE-API-KEY

string

required

API Key for accessing this service

Path Parameters

query_id

integer

required

unique identifier of the query

Query Parameters

parameters

object[]

Query parameters in key-value pairs. Each parameter is an object consisting of keys such as 'key', 'type', 'value', and optionally 'enumOptions'. The API allows for partial submission of parameters. For example, if the query expects three parameters and you only pass in two, the third one will automatically use its default value as defined in the API. This feature enables you to customize the query execution according to your specific needs while providing sensible defaults for unspecified parameters.

Show child attributes

parameters.key

string

required

The key name of the parameter.

parameters.description

string

A brief description of the parameter.

parameters.value

string

The default value used by this parameter during execution, format depends on the type.

parameters.values

string[]

An array of string values, used when multiple selections are allowed.

parameters.type

enum<string>

The type of the parameter, determines the format of 'value(s)'. 'number': Numeric parameters, the value must be a number (e.g., '20'). 'text': String parameters, value can be any text including hex 0x-prefixed values (e.g., '0xae2fc...'), an empty value defaults to an empty string. 'datetime': Date and time parameters, value must be in 'YYYY-MM-DD hh:mm:ss' format (e.g., '2021-12-31 23:59:59'). 'enum': Parameters with a specific list of values, 'EnumValues' field is mandatory, providing a JSON list of strings representing valid options, the 'value' must be one of these options (e.g., 'Option1').

Available options:

number,

text,

datetime,

enum

parameters.EnumValues

string[]

List of valid options for 'enum' type parameters.

parameters.isMultiselect

boolean

Indicates if multiple selections are allowed for this parameter.

parameters.isFreeformAllowed

boolean

Indicates if freeform input is allowed for this parameter.

parameters.enumFromResults

object

Show child attributes

parameters.enumFromResults.query_id

integer

The ID of the query to fetch results from.

parameters.enumFromResults.columnName

string

The column name to use from the query results.

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

text/csv

OK

The response is of type string.