Working with Azure Cosmos DB: Loading Data

In this course, you will examine how data is loaded into Cosmos DB, including data migration from a relational database and how to query that data.

Begin by using the Cosmos DB web console to load items into a container, focusing on the types of data that can be loaded, like arrays and nested JSON structures. Then, you will query these items using an SQL-like syntax and explore array indexing, in-partition and cross-partition queries, as well as intra-document joins in order to unpack arrays. Then, you will migrate data from a relational Azure SQL Database to Cosmos DB using Azure's Data Factory service, which allows you to define and launch a pipeline for a migration using an intuitive web UI. Finally, you will define a step to copy specific data from a source database and then migrate it over to a Cosmos DB container, assembling all the little pieces required for such a pipeline.