Converting JSON Objects to Relational Tables: Flattening the Object

added by DotNetKicks
6/1/2021 5:39:33 PM


Practical .NET Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data around but not so hot when you need to convert it into data stored in a relational database -- it's a problem complex enough that you might consider using a document-oriented or other NoSQL database rather than using a relational database.