Dune

Birkini supports direct querying of onchain data from Dune inside DuckDB. This lets you work with both proprietary and public blockchain data in one unified environment.

Syntax

SELECT * FROM @dune.[your_query_id] LIMIT 10;

Example Scenario

You can upload your own datasets, such as internal labels, and perform joins directly against public Dune queries within the same workspace.

Getting Started

1

Sign Up Navigate to the integrations section in your workspace and choose Dune.

2

Add Your Dune API Key Locate your API key in the Dune settings panel and enter it in the provided field within Birkini.

3

Find the Query ID In a Dune URL such as https://dune.com/queries/3593117/6053355, the query ID is the first number: 3593117.

4

Query from DuckDB Use the following format to begin querying Dune data:

SELECT * FROM @dune.3593117 LIMIT 10;