dbt and Snowflake image

dbt and Snowflake

Integrate dbt Cloud with Snowflake to ship trusted data faster. Thousands of teams use dbt Cloud to build on Snowflake at scale.

The easiest way to build data assets on Snowflake

Elevate your data pipeline development and administration using dbt Cloud’s seamless integration with Snowflake.

  • Scale with ease. Control run-time and optimize resource usage by selecting a unique Snowflake warehouse size for each dbt model.
  • Build with better tools. Maintain separate production and development environments and leverage git-based version control.
  • Protect sensitive data. Manage access to sensitive data with Snowflake’s dynamic data masking and dbt Cloud’s fine-grained access controls.
  • Simplify administration. Execute and version control administrative tasks related to dbt projects using dbt hooks and operations macros.

Faster time-to-value

Build data assets with modular code and automated dependency handling to get started with Snowflake even faster.

Better governance and data quality

Develop data pipelines with engineering best practices like CI/CD, version control, testing, and documentation as you code.

Scalability and cost management

Control run-time and effectively manage resources with Snowflake-specific configurations.

dbt Labs named a Leader in Integration and Modeling

“Marketing professionals are seeing the value of operating with the full breadth of their data, thanks to the Snowflake Data Cloud. For the second year in a row, dbt Labs was named a Leader in the Integration and Modeling category. Joint customers integrate dbt with Snowflake to improve data uptime, ship trusted data faster, and build data assets at scale.”

-- Denise Persson, Chief Marketing Officer at Snowflake

Produce quality datasets like industry leaders

Learn how leading organizations use dbt Cloud and Snowflake to ship trusted data faster.

  • McDonald’s leveraged dbt Cloud to implement a Datavault strategy on Snowflake.
  • Jetblue Improved data uptime from 65% to 99.9% with dbt Cloud and Snowflake.
  • Reforge used dbt Cloud to save 18 hours of Snowflake query time per week.
  • Sunrun automates SOX compliance on dbt Cloud + Snowflake.
  • TIER Mobility manages 350,000+ e-mobility assets with dbt Cloud and Snowflake.
  • MaxMine reduced time to insight by 80% by adopting dbt Cloud on Snowflake.

Combine Snowpark and dbt Cloud for smarter production

Use dbt’s integration with Snowpark to leverage Python and SQL together for more efficient data munging. It lets you empower machine learning workloads on Snowflake—all within the dbt transformation framework.

Snowflake's Data Integration Partner of the Year

We’ve been named Snowflake’s Data Integration Partner of the Year. We’ve been working hard to bring incredible value to the Snowflake ecosystem. And, our journey doesn’t end here! Book a demo with an expert to learn more.

Start building with Snowflake and dbt

See dbt + Snowflake in action

Watch this hands-on lab to see the power of using dbt and Snowflake together.

See it here

Start building now

Ready to build? Get started with our Snowflake quickstart tutorial and detailed documentation.

Go to quickstart

Book an expert-led demo

Learn how dbt Cloud and Snowflake can help your team and get custom insights from a dbt expert.

Book a demo