Transform Dune Data with dbt Connector
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
Transform Dune data with dbt Connector, then get the resulting dataset in Snowflake, BigQuery, Databricks or Amazon S3.
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.
Run your dbt models on DuneSQL across 130+ chains of decoded tables, stablecoins, DEX trades and wallet activity — no data movement, no pipelines. Datashare then syncs the production tables you built straight into Snowflake, BigQuery, Databricks, or Amazon S3. Because you sync your output instead of the raw chain, data-heavy chains like Solana get dramatically cheaper.
How dbt Connector 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.