Intro

We’re excited to announce support for Dune natively in the DuckDB shell on Chakra. Dune is one of the most powerful tools for crypto research.

It’s platform has now been integrated into a variety of open-source tooling, including:

• Paradigm’s Spice: a Python SDK with tight integration with Polars
• Spellbook: an interpretation layer allowing anyone to contribute DBT models to the Dune anthology

With this integration, users of the Chakra data warehouse (and soon the DuckDB community broadly), will be able to query Dune directly from DuckDB.

As we’ve addressed in our previous blogs, DuckDB is the fastest growing primitive in data.

• It is an in-process SQL database system that allows you to analyze data quickly and efficiently. It uses a columnar-vectorized query engine, processes data in batches, and efficiently uses the CPU cache, making it 20-40 times faster than traditional relationship databases.
• It’s easy to use. It uses an industry standard SQL dialect that most data scientists and engineers are already comfortable with.

Key Use Cases: Onchain and Offchain - All in One Place

With the DuckDB integration, users now have a convenient and fast way to analyze both their on and off-chain data directly in one place.

Users can upload their own key datasets (like proprietary labels) and join them against Dune data directly in one unified experience.

What’s Next: Open Source Extension?

Over the coming weeks, we’ll be testing this extension with our users and open sourcing it as a public good to the DuckDB community.

Dune is incredibly valuable and combining it with the fastest growing in-memory database only makes the experience for end-analysts that much better.

To try out this integration, check out the docs here.

To learn more about Dune, checkout their website and follow them on X.