What are the differences between the Dune API and the Dune web app?
There are no major performance differences within a specific performance tier when used through the Dune API or Dune web app.The Dune API gives you programmatic access to the capabilities and data sets that can already be accessed from the Dune web app. The same queries and results exist in the web app, even if created/executed from the API (and vice versa).
What are Sim APIs and how do they differ from the Dune API?
Sim APIs, formerly Echo, are a separate, developer-focused product by Dune, providing realtime access to EVM and SVM blockchain data.
They are designed for building apps like realtime wallets and AI agents.Sim APIs have their own documentation at docs.sim.dune.com, use a separate API key (X-Sim-Api-Key), and are optimized for low latency, realtime use cases.The Dune API primarily focuses on executing SQL queries you’ve written on Dune, managing those queries, and uploading data.
The API rate limit currently varies by subscription plan. It’s currently 40 per minute on free, 200 per minute on plus, and 1000 per minute on premium.
You currently cannot paginate through the API, we are working on enabling this soon. For now, try and use LIMIT and OFFSET in your query with parameters to paginate manually.
When navigating to a query, it’s the first number after “/queries/” in the URL. For example in https://dune.com/queries/241/388, “241” is the query id.
What is the difference between the states “Executing” and “Pending”?
Pending means, the execution is waiting for an available execution connection slot.Executing means the query is currently executing against the database.
Use “Import Data” to import your CSV results into a google sheet using “api_key” as a param. (We advise against doing this any public document where your API key can be viewed and compromised.)
=importData("https://api.dune.com/api/v1/query/{{query_id}}/results/csv?api_key={{api_key}}"). Then, schedule a query execution to have your results regularly updated on a set schedule.