Execute query and get result in one call
Execute query and get result in one call
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 dataframeperformance
parameter, by default it will use the “medium” performance tier. Credits are consumed based on actual compute resources used. “large” tier provides more resources for complex queries.
Returns an execution_id associated with the triggered query execution and the state of the execution.
Headers
API Key for the service
Path Parameters
Unique identifier of the query
Query Parameters
Alternative to using the X-Dune-Api-Key header
The performance engine tier the execution will be run on. Can be either medium
or large
. Credits are consumed based on actual compute resources used. Medium is the default, large provides more resources for complex queries.
medium
, large
SQL Query parameters in json key-value pairs. Each parameter is to be provided in key-value pairs. This enables you to execute a parameterized query with the provided values for your parameter keys. Partial submission of parameters is allowed. 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 Query Parameter Editor page.