Analyze Azure CosmosDB data using Azure Synapse Link and Transact-SQL language

%3CLINGO-SUB%20id%3D%22lingo-sub-1822786%22%20slang%3D%22en-US%22%3EAnalyze%20Azure%20CosmosDB%20data%20using%20Azure%20Synapse%20Link%20and%20Transact-SQL%20language%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsynapse-analytics%2Foverview-what-is%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Synapse%20Analytics%20workspace%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bis%20advanced%20analytic%20solution%20that%20enables%20you%20to%20analyze%20various%20data%20sources%20in%20Azure%20cloud.%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fcosmos-db%2Fsynapse-link%3Ftoc%3D%2Fazure%2Fsynapse-analytics%2Ftoc.json%26amp%3Bbc%3D%2Fazure%2Fsynapse-analytics%2Fbreadcrumb%2Ftoc.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Synapse%20Link%20for%20Azure%20Cosmos%20DB%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bconnects%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsynapse-analytics%2Foverview-what-is%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Synapse%20Analytics%20workspace%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bwith%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fcosmos-db%2Fanalytical-store-introduction%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20CosmosDB%20analytical%20store%20(preview)%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bthat%20contains%20a%20copy%20of%20Cosmos%20DB%20data%20highly%20optimized%20for%20analytic%20workloads.%20With%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fcosmos-db%2Fsynapse-link%3Ftoc%3D%2Fazure%2Fsynapse-analytics%2Ftoc.json%26amp%3Bbc%3D%2Fazure%2Fsynapse-analytics%2Fbreadcrumb%2Ftoc.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Synapse%20Link%20for%20CosmosDB%3C%2FA%3E%3CSPAN%3E%2C%20you%20can%20run%20complex%20analytic%20and%20create%20reports%20on%20top%20data%20stored%20in%20Cosmos%20DB%20analytical%20store%20without%20impacting%20the%20main%20Cosmos%20DB%20transactional%20containers.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Analyze%20Azure%20CosmosDB%20data%20using%20Azure%20Synapse%20Link%20and%20Transact-SQL%20language.png%22%20style%3D%22width%3A%20998px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229507i864968EE81DE7D96%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Analyze%20Azure%20CosmosDB%20data%20using%20Azure%20Synapse%20Link%20and%20Transact-SQL%20language.png%22%20alt%3D%22Analyze%20Azure%20CosmosDB%20data%20using%20Azure%20Synapse%20Link%20and%20Transact-SQL%20language.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20addition%20to%20the%20languages%20available%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsynapse-analytics%2Fspark%2Fapache-spark-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EApache%20Spark%20in%20Azure%20Synapse%20Analytics%3C%2FA%3E%2C%20you%20can%20also%3CSTRONG%3E%26nbsp%3Buse%20Transact-SQL%20language%20to%20analyze%20data%20in%20Cosmos%20DB%20analytical%20store%3C%2FSTRONG%3E.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsynapse-analytics%2Fsql%2Fon-demand-workspace-overview%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EServerless%20Synapse%20SQL%20pool%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eenables%20you%20to%20run%20T-SQL%20queries%20on%20top%20of%20your%20Cosmos%20DB%20analytical%20data.%3C%2FP%3E%0A%3CP%3ERich%20T-SQL%20surface%20enables%20a%20large%20ecosystem%20of%20tools%20and%20applications%20to%20directly%20query%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fcosmos-db%2Fanalytical-store-introduction%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECosmos%20DB%20analytical%20data%3C%2FA%3E.%20You%20can%20easily%20explore%20data%20in%20analytical%20store%20of%20CosmosDB%20container%20using%20T-SQL%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fsql%2Fdevelop-openrowset%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOPENROWSET%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efunction.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22JovanPop_1-1602849396940.png%22%20style%3D%22width%3A%20747px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229509i8C8B6517F783483B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22JovanPop_1-1602849396940.png%22%20alt%3D%22JovanPop_1-1602849396940.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-synapse-analytics%2Fanalyze-azure-cosmosdb-data-using-azure-synapse-link-and%2Fba-p%2F1787875%22%20target%3D%22_self%22%3E%3CSTRONG%3ERead%20the%20full%20article%3C%2FSTRONG%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1822786%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Cosmos%20DB%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Synapse%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Azure Synapse Analytics workspace is advanced analytic solution that enables you to analyze various data sources in Azure cloud. Azure Synapse Link for Azure Cosmos DB connects Azure Synapse Analytics workspace with Azure CosmosDB analytical store (preview) that contains a copy of Cosmos DB data highly optimized for analytic workloads. With Azure Synapse Link for CosmosDB, you can run complex analytic and create reports on top data stored in Cosmos DB analytical store without impacting the main Cosmos DB transactional containers.

 

Analyze Azure CosmosDB data using Azure Synapse Link and Transact-SQL language.png

 

In addition to the languages available in Apache Spark in Azure Synapse Analytics, you can also use Transact-SQL language to analyze data in Cosmos DB analytical storeServerless Synapse SQL pool enables you to run T-SQL queries on top of your Cosmos DB analytical data.

Rich T-SQL surface enables a large ecosystem of tools and applications to directly query Cosmos DB analytical data. You can easily explore data in analytical store of CosmosDB container using T-SQL OPENROWSET function. 

 

JovanPop_1-1602849396940.png 

Read the full article

 

0 Replies