Data As Code

Applying Software Engineering practices to Data Engineering with emphasis on Test-driven development (TDD)

Friday, June 21, 2024

JSON is now a first class citizen in Azure SQL Server

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

at June 21, 2024

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Re: Snowflake now supports CREATE OR ALTER TABLE DDL

One thing I noticed is that CREATE OR ALTER is not supported for MASKING POLICY or any other NETWORK POLICY. Hopefully Snowflake adds suppor...

Equivalent of Matillion's Detect Changes in DBT

I am a fan of Test Driven Development (TDD). Basically I define tests based on the requirements, and then write code till those tests are s...
Re: Data Quality Monitoring using Data Metric Functions Snowflake

An detailed video overview of the Data Metric Functions in Snowflake: https://www.youtube.com/watch?v=M4MadvJH_Dc Saqib On Mon, Jun 10, 2024...
Re: Snowflake now supports RANGE Clause in Window Functions

A detailed blogpost by Yogitha Chilukuri on the RANGE Clause in Snowflake Windows Function: https://medium.com/snowflake/now-in-public-previ...

Query Optimization in Snowflake (QOSF)

sql.edu.scot - forum.edu.scot. Simple theme. Powered by Blogger.