dbt Connector - Data Transformation | Dune
Dune as your Crypto Data Warehouse
Read data, write transformations, and analyze results all in one place.
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
Define your models
Build modular, reusable transformations using dbt's proven best practices.
Version with Git
Collaborate with your team using Git workflows for review, testing, and deployment.
Run transformations
Execute dbt models directly on Dune's comprehensive blockchain data—no data movement required.
Monitor and test
Ensure data quality with automated testing and real-time pipeline monitoring.
Deploy to production
Ship with separate dev and prod environments, then export production datasets to your warehouse with Datashare.