Zach Anderson
Apr 03, 2026 17:25
Dune’s new dbt connector lets data teams transform onchain data before syncing to Snowflake or BigQuery, eliminating post-delivery pipeline work.
Dune Analytics has rolled out a dbt connector that lets enterprise data teams transform blockchain data before it hits their warehouse—a capability the company claims no other provider currently offers.
The product, dubbed dbt connector → Datashare, creates a direct pipeline from Dune’s catalog of 130+ blockchain networks to Snowflake or BigQuery. The twist: users can apply business logic, filter protocols, and aggregate data using dbt models on DuneSQL before anything gets synced.
Why Data Teams Should Care
Anyone who’s worked with blockchain data providers knows the drill. You receive pre-configured tables, then spend engineering hours building transformation pipelines in your own infrastructure to make the data actually usable. That’s where budgets get burned.
Dune’s approach flips this. Write your transformations in dbt—a tool most data teams already use—and the shaped output is what arrives in your warehouse. A post-hook automatically registers model outputs as synced tables, with Dune handling incremental updates.
For data-heavy chains like Solana, this could meaningfully reduce transfer costs. You’re not pulling raw firehose data and filtering afterward; you’re defining exactly what gets delivered upfront.
The Three-Step Process
Start with Dune’s data catalog: decoded tables, curated datasets for stablecoins, DEX trades, wallet activity across any supported chain. Write dbt models directly on DuneSQL to join tables, apply filters, and aggregate by whatever cohorts matter to your business. The output syncs automatically to your warehouse, ready to join against off-chain data like CRM records or product analytics.
Base’s team reportedly used the dbt connector to create Builder’s code tables in under an hour, according to a case study Dune published alongside the announcement.
Who This Is For
This isn’t a retail product. It’s aimed squarely at enterprise data teams already running dbt workflows who need blockchain data integrated into existing analytics infrastructure. If your organization is building dashboards that combine on-chain wallet activity with off-chain customer data, this eliminates a layer of pipeline maintenance.
Teams already using Dune’s dbt Connector can enable Datashare access through the company’s sales team. For those evaluating the tool, Dune has published a demo walkthrough covering the technical implementation.
Image source: Shutterstock
Credit: Source link
