Tutorial: How to run dbt projects directly on Dune

Описание: Do you currently face these struggles in your workflow on Dune?
Recurring, complex data lineages with many dependencies and sources
Heavy usage caused by frequent full-refreshes which are compute inefficient
Querying historic data often times out in app
…

Meet dbt Connector. It empowers you to build, test, and deploy transformation pipelines with full support for incremental models, testing frameworks, and CI/CD orchestration.

What is dbt Connector?

The dbt Connector lets you run dbt directly on Dune’s warehouse. It turns Dune into a full data engineering environment, not just a place to query. With dbt, you can manage data dependencies, data quality tests, and materialization strategies, addressing the current limitations of materialized views and manual refreshes on Dune.

With it, you can:

Write and transform data using dbt’s dependency graph
Build pipelines with incremental models and CI/CD workflows
Collaborate via Git-based reviews and version control
Analyze and visualize directly in Dune
Everything from raw blockchain data to dashboards, all in one platform.

Why dbt on Dune?
Full incremental support: Use merge, delete+insert, or append strategies for efficient updates.
Testing framework: Validate data quality with dbt’s built-in testing capabilities
​- Drop-in compatibility: Works with your existing dbt projects and workflows
Version control: Manage transformation logic in Git with PR reviews
Private by default: Keep proprietary transformation logic within your organization
No Spellbook Dependency

Dbt connector is an enterprise-only feature on Dune.

Have any questions or looking to access dbt connector on Dune? Book a time with our data expert. https://calendly.com/d/cwnp-5wm-mq3/3...