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
[PUBLIC COPY] From slow to swift: Proven methods for optimizing your dbt project - Google Slides
Loading…
This could take a few moments
1
Loading…
Parts of this slide didn't load. Try reloading Reload
Erase allShift+A
Some slides didn't load. Refresh
Open speaker notesS
Turn on the laser pointerL
Turn off the laser pointerL
Turn on the penShift+L
Turn off the penShift+L
Enter full screenCtrl+Shift+F
Exit full screenCtrl+Shift+F
Swap displaysD
Exit slideshowEsc
Auto-play►
Captions preferences
More►
Q & AA
Download as PDF
Download as PPTX
PrintCtrl+P
Open in editor
Keyboard shortcutsCtrl+/
Report a problem
Report abuse
Ian Whitestone·Co-founder & CEO of SELECT
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.
Niall Woodward·Co-founder & CTO of SELECT
Niall is the Co-Founder & CTO of SELECT, a SaaS Snowflake cost management and optimization platform. Prior to starting SELECT, Niall was a data engineer at Brooklyn Data Company and several startups. As an open-source enthusiast, he's also a maintainer of SQLFluff, and creator of three dbt packages: dbt_artifacts, dbt_snowflake_monitoring and dbt_query_tags.