Share via

External table in azure sql with source from Azure Cosmos DB

Rakesh Reddy Charla 1 Reputation point Microsoft Employee
2021-05-10T20:27:48.787+00:00

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 Database
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,726 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,801 Reputation points
    2021-05-11T08:24:08.297+00:00

    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

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.