December 2019
Intermediate to advanced
494 pages
11h 41m
English
Cosmos DB provides a SQL layer over a document database. The data is stored in collections as JSON, just like they are with MongoDB. However, retrieving that data can be done using SQL queries instead of MongoDB JavaScript objects. That being said, SQL is not entirely what you're used to. While most of it looks the same, some operators, such as LIKE, are not supported. Because we're still dealing with a schemaless JSON database, other functions have been introduced. For example, STARTSWITH, ENDSWITH, and CONTAINS make up for the lack of the LIKE operator, while IS_DEFINED checks whether a property has been defined on a document:
All your documents can be queried through an HTTP-based RESTful API. For example, to get a document, ...