Quick Start With Azure Cosmos DB - Day Five

Akshay Patel
Feb 18, 2019

13.4k
0
6
- facebook
- twitter
- linkedIn
- Reddit
- WhatsApp
- Email
- Print
- Other Artcile

In this article, we will see how we can execute the SQL queries on JSON documents and get filtered results.

Please go through my previous articles of this series to get a complete understanding of the topic.

So far, we have created Cosmos DB and documents under collection. Now, we need to check how we can fetch the records using SQL queries.

Log into the Azure portal.
Select Azure Cosmos DB Service and select the database, i.e., Recharge in our case.
Expand the Prepaid collection and click on Documents, which will load the first 100 documents. In order to load more documents, you should click on the "Load More" link which will load another 100 documents.
On top of the documents list, we can see this SQL query - "SELECT * FROM c".
Click on the "Edit Filter" button.

Once we click the "Edit Filter" button, it will enable the textbox to write the query and convert it into the "Apply Filter" button.

Write your filter query in the textbox and click on the "Apply Filter" button.

Query On Cosmos DB And Download Documents

The filtered result will be displayed. Just click on id to explore the document.

Now, let's see how we can download the complete dump or our filtered result in the form of JSON document. For this, we need to download a free migration tool from the Microsoft website.

Download DocumentDB Migration Tool

In order to connect this tool to our Cosmos DB, a connection string is required which we can get from the Azure portal.

Under Settings, click on Keys where we get the URI, two keys, and two connection strings. You can use any of the connection strings to connect to Cosmos DB. The question may arise why two sets of keys and connection strings are given. The reason behind is that you can use one connection string while changing the other in production.