Dune as your Crypto Data Warehouse
Read data, write transformations, and analyze results all in one place.
Book a demo
Build sophisticated multi-stage data pipelines with dbt Connector
Read
Read from Dune's comprehensive blockchain datasets across all chains.
Transform
Transform and enrich with your proprietary business logic.
Create
Create reusable intermediate datasets for downstream analytics.
Connect
Chain dbt transformations into products, then deliver to your warehouse with Datashare.
Enterprise-Grade Crypto Data Warehouse
Drop-in compatibility
Integrate with your current dbt projects, Airflow DAGs, or Prefect flows.
Incremental queries
Process only the new or updated data you need, reducing run time and cost.
Git-native workflows
Review, test, and deploy transformations with full version control.
Private by default
Keep proprietary logic secure—transformations and datasets stay private unless you share them.
Full trails and lineage
Maintain complete visibility from raw data to final analytics with Git-tracked lineage.
Data quality assurance
Validate data quality with dbt's built-in testing capabilities.
Any dataset, any transformation, directly in your warehouse.
Dune's dbt to Datashare connector allows you to tap into 130+ chains of decoded tables, stablecoins, DEX trades, and wallet activity, run your dbt models on DuneSQL without shifting data, and sync production-ready tables directly to Snowflake or BigQuery. Get huge savings on data-heavy chains like Solana by only syncing the exact data you need.
How dbt works
Build modular, reusable transformations using dbt's proven best practices.
Collaborate with your team using Git workflows for review, testing, and deployment.
Execute dbt models directly on Dune's comprehensive blockchain data—no data movement required.
Ensure data quality with automated testing and real-time pipeline monitoring.
Ship with separate dev and prod environments, then export production datasets to your warehouse with Datashare.