Did you know that simply changing the # of threads on dbt can improve your pipeline's performance?
Increased # of threads = queries queued in the data warehouse instead of dbt
dbt is no longer the bottleneck, your warehouse is!
Thanks @ianwhitestone for the tip!
We finally got some time to I finally got some time properly reflect on everything @SnowflakeDB announced last week at Summit 2023.
Learn about every announcement and our thoughts on each in our latest post👇
Back in March we had the opportunity to speak at @DataCouncilAI in Austin. We had a blast sharing everything we've learned about @SnowflakeDB cost and performance optimization.
Slides & recording now available 👇
select.dev/posts/data-cou…
Another great post from @select_dev about CTEs.
Summary:
- continue using CTEs 🤘
- specify column names (don't "import" with select *)
- for special queries, experiment with repeating logic instead of reusing CTEs
- learn how to read query plan
select.dev/posts/should-y…
