Not able to connect to cosmos Db in synapse using managed identity in Notebook

Sonali Dubey 0 Microsoft Employee

YI have try the below steps to connect Azure Cosmos DB using Apache Spark 2 in Azure Synapse Link:

Step1: Go to Linked and select the Azure Cosmos DB linked service and test the connection.

Step2: Select the container and click on actions => New Notebook => Load streaming DataFrame from container.

Step3: Select the Spark pool and run the code to load the dataframe from container.

but we are still getting error.

Error :Py4JJavaError: An error occurred while calling o4047.load. : java.lang.RuntimeException: Resolving Azure CosmosDB LinkedService [SynapseCosmosDbMIConnect] in Azure Synapse failed.Validate the configured LinkedService. If still seeing this, try using the Azure CosmosDB account name and credentials directly.

Please let us know which approach we should use.

Harishga 3,505 Reputation points Microsoft Vendor

2024-03-25T11:21:11.2933333+00:00

Hi @Sonali Dubey
Could you please share the complete Stack trace error message so that we can debug the issue further?
Harishga 3,505 Reputation points Microsoft Vendor

2024-03-26T22:04:17.79+00:00

Hi @Sonali Dubey
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.