# 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](https://docs.dune.com/api-reference/connectors/dbt/datashares#dbt-to-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](https://dune.com/datashare).

## Start transforming your data

[View docs](https://docs.dune.com/api-reference/connectors/dbt/overview#dbt-connector-overview)