[Analytics Engineering] 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
- Previous message (by thread): [Wranglers] dbt snapshots as a first class citizen
- Next message (by thread): [Wranglers] Snowflake now supports Variable Binding in Queries using TO_QUERY()