Intro

Chakra supports querying data from Dune natively in DuckDB, allowing users to analzye off-chain and on-chain data in one place.

Syntax:

SELECT * FROM @dune.[insert_query_id_here] LIMIT 10

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