Using SQL to get data from Cosmos

RichHead 1

Newbie question, we've recently started using cosmos and I have been asked to pull data from cosmos to merge with data pulled from a SQL database, when trying to establish the linked server, it results in a tabular view of the data, based on sample data... which is not representative of the full data available... I have less columns in the tabular view of the data than exists in some documents. How do I resolve this?

Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2022-03-18T22:01:40.787+00:00

Hi @RichHead , thank you for posting your Question on Microsoft Q&A and for using Azure services.
If my understanding is correct, you are trying to merge data from cosmos dB with data in Azure SQL database. You have tried to create a linked server, but it resulted to some missing data. Please correct me if my understanding is not correct.
Are you using Data Factory?

Regards,
Oury

Share via

Using SQL to get data from Cosmos