Query Azure Cosmos DB data using a serverless SQL pool in Azure Synapse Link - Azure Synapse Analytics

By Docs - 2021-03-10

Description

In this article, you'll learn how to query Azure Cosmos DB by using a serverless SQL pool in Azure Synapse Link.

Summary

In this article A serverless SQL pool allows you to analyze data in your Azure Cosmos DB containers that are enabled with Azure Synapse Link in near real time without affecting the performance of your transactional workloads.
By omitting the WITH clause from the OPENROWSET statement, you can instruct the serverless SQL pool to autodetect (infer) the schema of the analytical store of the Azure Cosmos DB container.
Create view Creating views in the master or default databases is not recommended or supported.
Since a serverless SQL pool queries the analytical store, it's important to understand how to map Azure Cosmos DB input data types to SQL data types.

Topics

Backend (0.25)
Mobile (0.11)
Database (0.1)

Similar Articles

Azure Synapse Link for Azure Cosmos DB, benefits, and when to use it

By Docs - 2021-01-14

Learn about Azure Synapse Link for Azure Cosmos DB. Synapse Link lets you run near real-time analytics (HTAP) using Azure Synapse Analytics over operational data in Azure Cosmos DB.

Unlocking the Power of SQL on Azure Cloud 2021 | MSP Expert

By Hanu - 2021-03-01

Given that it's becoming difficult to leverage data for business decisions, can you unlock the potential of your SQL databases with SQL on Azure?

Scale your cloud app with Azure Cache for Redis | Azure Friday

By Channel 9 - 2021-02-09

Ye Gu joins Scott Hanselman to discuss Azure Cache for Redis, a popular open-source in-memory data store that uses DRAM to store the most frequently used or time-sensitive data for fast retrieval. Wit

Confluent’s Kafka Platform Becomes a ‘First Party’ Service for Azure

By The New Stack - 2021-02-02

Confluent’s commercial Kafka platform for managing streaming data now can work seamlessly with with Microsoft Azure such that Azure customers can access Confluent Cloud without "ever leaving the Azure ...

Introduction to Azure Spring Cloud

By Docs - 2021-01-07

Learn the features and benefits of Azure Spring Cloud to deploy and manage Java Spring applications in Azure.

Using Azure Machine Learning from GitHub Actions

By Azure DevOps Blog - 2020-12-23

Azure Machine Learning is an Enterprise-grade Machine Learning service that can help you build and deploy your predictive models faster. It also has a number of features to help you mature your machin ...