Data Warehouse
Dune
Querying on-chain data directly in DuckDB
Intro
Chakra supports querying data from Dune natively in DuckDB, allowing users to analzye off-chain and on-chain data in one place.
Syntax:
Example Use-Case
An example use-case: users can upload their own key datasets (like proprietary labels) and join them against Dune data directly in one unified experience.
Getting Started
1
Sign-Up
Navigate to integrations and select Dune.
2
Add your Dune API key
You can find this directly in the Dune settings page.
3
Identify the Query Id
The query_id
in a Dune URL is the first number in the URL.
For example, for this query https://dune.com/queries/3593117/6053355, the query_id
is 3593117
4
Start querying data in DuckDB
SELECT * FROM @dune.[insert_query_id_here] LIMIT 10