Zach Anderson
Apr 03, 2026 17:25
Dune’s new dbt connector lets knowledge groups rework onchain knowledge earlier than syncing to Snowflake or BigQuery, eliminating post-delivery pipeline work.
Dune Analytics has rolled out a dbt connector that lets enterprise knowledge groups rework blockchain knowledge earlier than it hits their warehouse—a functionality the corporate claims no different supplier presently affords.
The product, dubbed dbt connector → Datashare, creates a direct pipeline from Dune’s catalog of 130+ blockchain networks to Snowflake or BigQuery. The twist: customers can apply enterprise logic, filter protocols, and combination knowledge utilizing dbt fashions on DuneSQL earlier than something will get synced.
Why Information Groups Ought to Care
Anybody who’s labored with blockchain knowledge suppliers is aware of the drill. You obtain pre-configured tables, then spend engineering hours constructing transformation pipelines in your individual infrastructure to make the information truly usable. That is the place budgets get burned.
Dune’s method flips this. Write your transformations in dbt—a software most knowledge groups already use—and the formed output is what arrives in your warehouse. A post-hook mechanically registers mannequin outputs as synced tables, with Dune dealing with incremental updates.
For data-heavy chains like Solana, this might meaningfully cut back switch prices. You are not pulling uncooked firehose knowledge and filtering afterward; you are defining precisely what will get delivered upfront.
The Three-Step Course of
Begin with Dune’s knowledge catalog: decoded tables, curated datasets for stablecoins, DEX trades, pockets exercise throughout any supported chain. Write dbt fashions straight on DuneSQL to hitch tables, apply filters, and combination by no matter cohorts matter to your enterprise. The output syncs mechanically to your warehouse, prepared to hitch in opposition to off-chain knowledge like CRM information or product analytics.
Base’s crew reportedly used the dbt connector to create Builder’s code tables in beneath an hour, in response to a case research Dune revealed alongside the announcement.
Who This Is For
This is not a retail product. It is aimed squarely at enterprise knowledge groups already operating dbt workflows who want blockchain knowledge built-in into current analytics infrastructure. In case your group is constructing dashboards that mix on-chain pockets exercise with off-chain buyer knowledge, this eliminates a layer of pipeline upkeep.
Groups already utilizing Dune’s dbt Connector can allow Datashare entry by means of the corporate’s gross sales crew. For these evaluating the software, Dune has revealed a demo walkthrough protecting the technical implementation.
Picture supply: Shutterstock
