SELECT

SELECT

Proven methods for optimizing your dbt project - dbt Coalesce 2023

This page is also available in Deutsch, Español, Français, Italiano, 日本語, and Português.

By Ian Whitestone & Niall WoodwardOct 29, 20232 min read

Presentation Overview

With increased adoption of dbt and ever growing data volumes, data teams are increasingly looking to make their dbt deployments more efficient. In this talk, SELECT's Ian Whitestone and Niall Woodward share tried and tested dbt cost and performance optimization best practices. The agenda covers:

  • Snowflake architecture & billing overview
  • Low hanging fruit
  • Identifying optimization opportunities
  • Orchestration
  • Materialization strategies
  • SQL query optimization

Recording

A recording of the presentation is available on YouTube.

If you would like, we are more than happy to come in and give this presentation (or a variation of it) to your team where they can have the opportunity to ask questions. Send an email to ian@select.dev if you would like to set that up.

Slides

Google Slides
Open slides