Upsert Operation in Cosmos DB using Azure Data Factory

This article covers the basics of upserting data in CosmosDB using Azure Data Factory.

Using Azure Synapse Link for Azure Cosmos DB

Learn how you can query CosmosDB data from Azure Synapse in this walkthrough.

An Introduction to Azure Cosmos DB

Introduction Azure Cosmos DB is Microsoft's globally distributed, multi-model platform-as-a-service (PaaS) database. Any web, mobile, gaming, and IoT application that needs to handle massive amounts of structured, semi-structured and unstructured data may use Azure Cosmos DB. Guaranteed high availability, high throughput, low latency, and tunable consistency help in reading and writing data at a global […]

Moving away from an RDBMS

Today Steve looks at an article the migrates a relational model to CosmosDB.

Creating a Azure Cosmos DB Account

Learn how to get started with a CosmosDB account.

Powershell Script - Azure cosmos DB(SQL API)

Scripts contains 4 following functions. Users can create 3 different script from this for inserting, fetching and deleting a document.
1. Function Generate-MasterKeyAuthorizationSignature - This function is used to create connection to Azure cosmos DB. This function codes were taken from Technet.
2. Function Post-CosmosDb - Insert single document in azure cosmos DB. Same function can be used to perform bulkinsert. This function code was taken from following article. To make it useful i made some modification in it.
(https://www.systemcenterautomation.com/2018/06/cosmos-db-rest-api-powershell/)
3. Function Get-CosmosDocument - Fetch single document from azure cosmos DB. Same function can be used to fetch all documents from Cosmos DB.
4. Function Delete-CosmosDbDocument - Delete single document from cosmos DB. Same function can be used to delete more than one document with some additional codes.

To use any of the function like Post,Get, Delete. you have to comment the other 2 function call. If you are using all 3 functions(Post,Get, Delete), Be cautious while using them.

Graphical Tools for Accessing Azure Cosmos DB

While the most common methods of interacting with Azure Cosmos DB involve programmatic access, there are times when you might want to perform a quick change or take a peek at some of documents in a collection. In such instances, it is typically more convenient to rely on the graphical interface. Fortunately, there are several options you can use to accomplish.

Introduction to the Cosmos DB Emulator

Cosmos DB delivers a wide range of advantages over traditional SQL and NoSQL-based data stores, including support for multiple consistency levels, latency and throughput guarantees, policy-based geo-fencing, automatic scaling, and multi-master replication model. However, it is a significant departure from the traditional database management and development approach that most database administrators are familiar with. Discover the offerings that you can use at no cost to gain hands-on experience with Cosmos DB.

SQL For Cosmos DB – Handling Complex JSON Structures

The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them...

Azure Cosmos DB – Real-time ETL using Change Feed and Azure Functions

Many people who read my Cosmos DB articles are looking for an effective way to export data to SQL, either on-demand or in real-time. After performing a search term...
The...