Skip to main content
Build data transformation pipelines on top of Dune’s blockchain data with write-enabled access to DuneSQL.

​
Overview

The dbt Connector provides write-enabled access to Dune’s data warehouse, allowing you to build sophisticated data transformation pipelines using dbt (data build tool). It uses the same Trino endpoint as the read-only connector but with the transformations=true session property enabled.
The dbt Connector requires an Enterprise plan. Contact sales for access.

​
Key Features

  • Write Access: Create tables, views, and materialized views directly in DuneSQL
  • dbt Integration: Full compatibility with dbt Core and dbt Cloud
  • Version Control: Manage your data models with Git-based workflows
  • Testing: Built-in data quality testing with dbt’s testing framework
  • Documentation: Auto-generate documentation for your data models

​
Common Use Cases

Data Transformation Pipelines

Build complex ETL pipelines that transform raw blockchain data into analytics-ready datasets

Custom Metrics & KPIs

Create reusable data models for protocol-specific metrics and business KPIs

Data Quality Assurance

Implement automated testing and validation for your blockchain data models

Scheduled Transformations

Automate data refreshes with dbt Cloud or your own orchestration tools

​
Getting Started

Setup Guide

Step-by-step instructions to connect dbt to Dune

Supported SQL Operations

Reference for supported DDL and DML operations