Today, Dune is launching dbt connector → Datashare: a complete end-to-end pipeline that takes you from raw onchain data to a custom, ready-to-query dataset in your Snowflake or BigQuery.
Start with Dune's full data catalog — 130+ chains, decoded tables, curated datasets for stablecoins, DEX trades, wallet activity, and more. Any chain, any dataset, any time.
Write dbt models directly on DuneSQL using our dbt connector. Join across tables, filter to specific protocols, apply your business logic, aggregate by wallet cohorts — whatever shape your data needs to be in.
This is the step no other data provider can offer. You're not receiving a pre-configured table and building transformations after the fact. You define exactly what gets delivered, using tools your data team already knows.
Think of how much transfer cost you could be saving on especially data-heavy chains like Solana.
A dbt post-hook automatically registers your model output as a synced table. Dune handles incremental syncs to keep your Snowflake or BigQuery up to date. The data arrives ready to join against your off-chain data — CRM, transactions, product analytics, whatever lives in your warehouse.
The problem with every other blockchain data provider isn't delivery. It's what happens before and after.
Customers need to define which data they care about, join across multiple tables, apply business logic, and filter to the right chains and protocols. Currently, that work happens after delivery, in your own warehouse, on data you weren’t able to shape.
You receive static, pre-configured tables and build transformation pipelines in your own infrastructure to make the data usable. That's where engineering time and budget get burned.
dbt connector → Datashare collapses both problems into one step. Define your transformations in dbt on Dune. The output is what gets synced to your preferred data warehouse.
If your team already runs dbt, there's no new tooling to learn. You write models the same way you always have — the difference is that you're running them against the most comprehensive onchain data catalog available, and the output goes directly to your warehouse.
Prototype and validate transformations using Dune's query engine. Update your dbt model when your logic changes — the sync follows automatically.
If you're already using Dune's dbt Connector, you're one step away from the full pipeline. Talk to our team to enable access→
Want to see how dbt connector works? Watch the demo →
Looking to use Dune for your company?
