Handle JSON with dbt // jinja & macros

FREE Modern Data Checklist to give you clarity → https://bit.ly/kds-checklist Project-based training to help you level-up → https://bit.ly/simple-stack Consulting to help you implement → https://bit.ly/kds-consulting A common data type you'll see in a modern stack is JSON. This is often used for data streams, software applications, etc. The tricky part as an engineer is trying to combine it with structured, relational data. Fortunately, most modern databases now have ways to store this data type. Add in the dynamic features of dbt and you can really simplify this task. In this video we will first look at how to flatten data in snowflake... Then use the dbt features of jinja and macros to create a reusable component in our project. Timestamps: 00:00 - Intro 00:38 - Review JSON Data 01:13 - Flatten JSON w/ Snowflake 02:35 - Flatten using Jinja & dbt 09:30 - Remove Trailing Comma 10:53 - Create a Reusable Macro Title & Tags: How to Flatten JSON Using Snowflake, DBT and Jinja | dbt tutorial #kahandatasolutions #dataengineering #databuildtool