question

RakeshReddyCharla-5483 avatar image
0 Votes"
RakeshReddyCharla-5483 asked Pittrecon08127 edited

External table in azure sql with source from Azure Cosmos DB

Hi

I have some data in Azure Cosmos DB and would like to access that data from Azure SQL through external tables.
Is there a way to create external table in Azure SQL with source = Azure Cosmos DB?

azure-sql-databaseazure-cosmos-db
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@RakeshReddyCharla-5483 Do you find the answer yet? I have same question now. Thanks.

0 Votes 0 ·

1 Answer

VaibhavChaudhari avatar image
1 Vote"
VaibhavChaudhari answered

At this moment, this is not possible. You can upvote below feedback -

https://feedback.azure.com/forums/217321-sql-database/suggestions/34363534-connection-to-cosmos-db

You can try to copy the data from Cosmos DB to Azure SQL using data factory and use this staged data.

See similar questions:

https://stackoverflow.com/questions/54176547/create-a-linked-server-connection-between-azure-sql-db-and-azure-cosmos-db
https://stackoverflow.com/questions/53603979/can-an-azure-hosted-sql-server-connect-with-an-azure-cosmos-db


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.