In this episode, we tackle a common challenge for modern data teams: What should you do with all that JSON and other semi-structured data flooding in from APIs, events, and third-party sources?

We break down when to store, when to split, and how to stay sane in a world of endlessly nested payloads.

📌 Chapters:

00:00 – Introduction

00:10 – Why semi-structured data is everywhere

01:02 – Store vs. split: making the right call

03:15 – Handling schema drift and variants

05:24 – Data contracts and API payload challenges

07:41 – Tips for integrating JSON in your warehouse

09:06 – Common mistakes to avoid

10:00 – Key takeaways & next steps

🔔 Don’t forget to like, comment, and subscribe!