Proven methods for optimizing your dbt project - dbt Coalesce 2023
Ian WhitestoneSunday, October 29, 2023
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 [email protected] if you would like to set that up.
Slides
Ian is the Co-founder & CEO of SELECT, a SaaS Snowflake cost management and optimization platform. Prior to starting SELECT, Ian spent 6 years leading full stack data science & engineering teams at Shopify and Capital One. At Shopify, Ian led the efforts to optimize their data warehouse and increase cost observability.
Want to hear about our latest Snowflake learnings?Subscribe to get notified.
Get up and running in less than 15 minutes
Connect your Snowflake account and instantly understand your savings potential.
