Using SQL to get data from Cosmos

RichHead 1 Reputation point
2022-03-18T15:47:51.753+00:00

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?

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,469 questions
{count} votes