Setting up Azure Cosmos DB analytical store

In this recipe, we will learn how to set up Azure Cosmos DB analytical store, which helps us to run near real-time analytical queries with operation data. CosmosDB is used as storage for real-time data and data that's near real-time, such as from IoT sensory devices.

Getting ready

Before we begin the recipe, create the resource group SynapseRG in the Azure portal.

How to do it…

We will create an Azure Cosmos DB account and learn how to set up the container in it. Let's get started:

1. Log in to Azure portal: https://portal.azure.com/#home.
2. Search for cosmos by using the top search bar on the Microsoft Azure page and navigate to Azure Cosmos DB.

Figure 4.3 – Search for Azure Cosmos DB

3. Click on Azure Cosmos DB.

Figure 4.4 – Create an Azure Cosmos DB account

4. Select Core (SQL) by clicking Create.

Figure 4.5 &...