CosmosDB data models and APIs

As mentioned earlier, Azure Cosmos DB offers five different database models, all sharing the same infrastructure and concepts. This is a great feature, that makes this service really flexible and able to serve multiple different purposes. In this section, I will briefly describe each database model, so you will be able to select one that best serves your purposes.

SQL

If you think about SQL, you probably see a relational database with tables, relations, and stored procedures. When working with SQL API in Cosmos DB, in fact you will work with documents that can be queried using the SQL syntax. Let us assume you want to query documents using the following call:

SELECT * FROM dbo.Order O WHERE...