Integrating an Azure Synapse ETL pipeline with Cosmos DB
In this section, we will understand Azure Synapse Link for Cosmos DB and its usage for real-time analytics. We will learn about the following topics:
- The basics of Cosmos DB
- Azure Synapse Link integration with Cosmos DB
- Feature support of Cosmos DB with Synapse
- Synapse runtime support
- Structured streaming support
- Security features of Cosmos DB
Introducing Cosmos DB
Azure Cosmos DB is a fully isolated columnar store for large-scale analytics with operational data and a transactional store that is schema-agnostic, which allows us to use it with transactional applications without the overhead of managing schema or indexes.
Azure Cosmos DB analytical store is optimized for use for analytical workloads, which offers good analytical query performance.
When operational data is stored in a transaction store in row store format, analytical queries would be expensive, since we need provisioned...
