how to use dbt snapshot to manage slowly changing dimensions
Are you tired of manually updating your dimensional tables? Do you dream of having a smooth, consistent data flow? We've got the solution for you! We are covering Slowly Changing Dimensions with DBT. What are slowly changing dimensions, you ask? Simply put, they're changes that occur over time in dimension tables, such as Changing employee titles, Merging departments, Updating product categories.
With DBT, you can automate these updates in a breeze! Say goodbye to manual data manipulation and hello to a more streamlined data warehouse.
In this vidoe we use DBT to successfully manage slowly changing dimensions. The result? A robust, scalable, and easy-to-maintain data warehouse that just keeps on growing!
Stay ahead of the curve with DBT and take your data warehousing skills to the next level! #DBT #SlowlyChangingDimensions #DataWarehouse"
Link to dbt snapshot: https://docs.getdbt.com/docs/build/sn...
Link to dbt repo: https://github.com/hnawaz007/dbt-dw
Link to sql scripts: https://github.com/hnawaz007/dbt-dw/t...
Link to dbt series: https://hnawaz007.github.io/mds.html
Link to Channel's site:
https://hnawaz007.github.io/
--------------------------------------------------------------
💥Subscribe to our channel:
/ haqnawaz
📌 Links
-----------------------------------------
#️⃣ Follow me on social media! #️⃣
🔗 GitHub: https://github.com/hnawaz007
📸 Instagram: / bi_insights_inc
📝 LinkedIn: / haq-nawaz
🔗 / hnawaz100
🚀 https://hnawaz007.github.io/
-----------------------------------------
Topics in this video (click to jump around):
==================================
0:00 - Overview of the Slowly Changing Dimensions
0:49 - DBT Snaphosts
2:16 - Create DBT Snaphost
3:49 - Build Snapshot
4:09 - Review Snaphost in database
4:43 - Update Source Table
5:34 - Re-build Snapshot
5:40 - Review Snapshot Changes
6:26 - Final thoughts