You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$10
For Premium members:
Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
Azure DocumentDB supports query JSON documents using familiar and friendly SQL syntax. If you know SQL, you can get up and running quickly with Azure DocumentDB. It also helps in quick writing the queries for DocumentDB API data by displaying common database queries, keywords, built-in functions, and operators in an easy to print PDF reference sheet. Cosmos DB supports relational, hierarchical, and spatial querying of JSON documents using SQL without specifying a schema or secondary indexes, JavaScript user defined functions (UDFs), JavaScript operators, and a multitude of built-in functions.Download the Cosmos DB SQL query cheat sheet PDF
This cheat sheet helps write DocumentDB queries quickly by showing some common SQL queries used to retrieve data from two simple JSON documents. For a relational database example, there are two key differences when writing queries on Azure DocumentDB.
The above SQL cheat sheet PDF shows common queries used to retrieve data from two example JSON documents. In case you are looking to run and test SQL, you can use Online Demo. You can also review SQL queries for Azure Cosmos DB DocumentDB API at MS Document.
Understanding Azure : A Beginner’s Guide