Setting up Azure Cosmos DB

 Ok, let's take it one by one. Let's start with setting up of a cosmos DB cluster. But before that lets discuss some general info about cosmos db. 

What is cosmos DB?

If you search Wikipedia, you will get following result.

Azure Cosmos DB is Microsoft's proprietary globally distributed, multi-model database service "for managing data at planet-scale" launched in May 2017.[1] It is schema-agnostic, horizontally scalable, and generally classified as a NoSQL database.

So, I can understand that it's a Microsoft provided NoSQL datastore which provides different properties as mentioned in its description. I am not going into the details of these properties in this article as it's beyond the scope of it. I would only discuss about how to set it up.

Now, let's jump on to the setup of cosmos DB.

How to setup cosmos DB? 

In order to do it, you need an azure account. In order to create a free one, you can use: Create Your Azure Free Account Today | Microsoft Azure you would get 200 dollars of free credits.

  1. Once you have the account, you would see something like this, click on select Create a resource.          
  2. Then, you would see this screen mentioned below, Select Azure cosmos DB.
  3. Next screen is going to ask you to select API option, select the Create option within the Core (SQL) - Recommend section. Azure Cosmos DB provides five APIs: Core (SQL) and MongoDB for document data, Gremlin for graph data, Azure Table, and Cassandra. Currently, you must create a separate account for each API. Learn more about the SQL API.
  4. Fill in the details according to your needs in the Basics section, here is my update but feel free to fill it according to your needs.

  5. In the global distribution section, select policy according to your needs I am going with default one

  6. Optionally, you can add more details in the following tabs, Network latency, Backup Policy, Encryption, Tags.


  7. Click review and create...
  8. Review all the settings and then click on create, wait for the instance to be up it may take up time up to few minutes.
  9. Once instance is created, click on go to resource to go to azure cosmos dB accounts page.
    Now Let's create a database and container to it. 

Database seems clear but what is container?

An Azure Cosmos DB container is a schema-agnostic container of arbitrary user-generated entities and stored procedures, triggers and user-defined-functions (UDFs). 

Now, let's talk about container creation:
  1. For creating container go to Data explorer section, select new container, then a window would pop up on the right side

  2. Select ok, a new DB instance can be seen under data explorer.
Let's add some data to our database:
  1. Click on the items under database and then click on new item tab.
  2. Add following Json:

  3. click on save and a new entry would be created with some extra fields

     
References:
  1. Wikipedia
  2. Microsoft cosmos DB docs.








Comments

Post a Comment

Popular posts from this blog

Kustov query language

Image
 In this post I would be talking about my experiences of learning KQL (Kustov query language). I started with this document  Kusto Query Language (KQL) overview | Kusto . From the documentation I get to know that it's a query language used for analytics purposes and uses up schema entities quite similar to SQL i.e., having database, tables, column. Then, document further talks about Kusto query which is basically a read only query for processing data. Types of querying: KQL supports 3 types of query statements. These are basically Let, Set, Tabular. Tabular: This is the most common way of querying. In this format a table is provided as an input and table is also taken up as output. Query consists of lot of operands which are connected by pipe (|). I know it's too much but let's take a look at a query and this would be crystal clear.  In this query we can see StormEvents is provided as input and then there are lot of operands which are connected using pipe (|). These pip...
Read more

Making all service APi's generic

 So, I was looking into an issue in which one our customer complaint about inconsistency of some of our interfaces. He specifically talked about status code of some of our API's and mentioned that some status codes are supported by some API's and not by others. What can I do to mitigate it? Improve up the documentation with details [asked by customer]. Look into the code: Code says that we are specifically handling this error (not found) and adding it inside the response. There might be some reason associated with it. How can I figure out the reasons? Check code commits Ask Product manager Some comments around that code Documentation of this feature or maybe issue fix for this bug  Asked for clarification from Product Manager let's see what happens.
Read more

How I learned LINQ query Fundamentals

Image
Some days back, I joined my new organization, and I came to know that my team extensively uses c# for their development purposes and I came from java background. By surfing through internet and watching some videos I was able to grasp basics of c# then started exploring code base my team. I saw that there are quite a lot of code pieces like: I found it bit difficult to understand as these are not part of c# syntax so after doing some google searches, I found that this is part of something called LINQ(Language-Integrated) queries which provides solution for object-relational mapping and simplifies operation between objects and data sources. Obviously, I had to learn more about it and become an advanced user, as my team is using it extensively.  Random thought: Yeah, it's okay I have to learn LINQ queries since my team is using it but why exactly they are using it?? Let's analyze advantages of LINQ: Familiar language: Developers don't have to learn a new query language for ...
Read more