JSON Support Now Generally Available in Azure SQL Database

Now, you can easily ingest JSON data and store it into Azure SQL Database, and use any language or tool compatible to query and analyze loaded information.

Share online:

JSON support now generally available in Azure SQL Database, letting you query and store both relational and textual data formatted in JavaScript Object Notation (JSON) using Azure SQL Database.

With this new JSON functionalities, you can also easily format data stored in Azure SQL Database as JSON and expose it to any modern service or application.

The integration also allow you to use JSON functions that enable you to extract value from "JSON text (JSON_VALUE), extract object from JSON (JSON_QUERY), update some value in JSON text (JSON_MODIFY), and verify that JSON text is properly formatted (ISJSON)," the team explained.

JSON support is generally available in Azure SQL Database

OPENJSON function enables you to convert JSON text into a table structure.

Finally, JSON functionalities also enable you to easily format results of any SQL query as JSON text using the FOR JSON clause.

If you're new, "JSON in Azure SQL Database enables you to build and exchange data with modern web, mobile and HTM5/JavaScript single-page applications, NoSql stores such as Azure DocumentDB that contain data formatted as JSON, and to analyze logs and messages collected from different systems and services, writes Jovan Popovic, Azure SQL Database program manager."

To integrate JSON in your application, learn more at the Getting Started page. And, to learn about scenarios on how to integrate JSON in your application, watch the videos below: