Blog Post

Azure SQL Blog
4 MIN READ

Native JSON type & JSON aggregates are now in private preview for Azure SQL Database

uc-msft's avatar
uc-msft
Icon for Microsoft rankMicrosoft
May 25, 2023
We are excited to announce the private preview of native JSON type and JSON_OBJECTAGG & JSON_ARRAYAGG aggregates in Azure SQL Database. The JSON type will allow you to store JSON documents in a nativ...
Updated May 25, 2023
Version 2.0
azure sql database
bamak's avatar
bamak
Copper Contributor
Nov 07, 2024

Any news about T-SQL  record /array new column type to store nested fields ? A clear schema DDL as contract for Json nested fields data on RAW layers

On some cases : RAW tables strong  storage contract ,  json  and varchar(max) T SQL types are not accurate 

 
Flatten for GOLD layer via unnest() T-SQL function
<== Like on Bigquery