[Wranglers] JSON is now a first class citizen in Azure SQL Server

Ali, Saqib docbook.xml at gmail.com
Fri Jun 21 18:55:38 UTC 2024


Azure SQL now supports JSON DataType. It is a binary data type that is way
more performant than using a non-binary datatype to store JSON.

https://www.youtube.com/watch?v=WigP5PLQXhY

More info:
https://learn.microsoft.com/en-us/sql/t-sql/data-types/json-data-type?view=azuresqldb-current
https://learn.microsoft.com/en-us/sql/t-sql/functions/json-objectagg-transact-sql?view=azuresqldb-current
https://learn.microsoft.com/en-us/sql/t-sql/functions/json-arrayagg-transact-sql?view=azuresqldb-current
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20240621/93ffe9dc/attachment.htm>


More information about the Wranglers mailing list