Where is the storage account key for cosmos db?

I have a copy data pipeline which loads data from a json file within a blob to a cosmos DB collection. Now the sink is the cosmos dB connection . At creation time account selection method is Azure subscription , subscription is selected and then Azure cosmos dB account is selected and then it shows an error message "Cannot get storage account key. [object Object]".

How can this be resolved ?

Other part when i enter the account selection method manually everything connects ok but while executing full pipeline it fails to find the connection and i get errors similiar to "The operation failed with server error. ConnectionId: '{ ServerId : { ClusterId : 1, EndPoint : "Unspecified/<cosmosdb url>:10255" }, LocalValue : 3"

1 answer

Dillon Silzer 54,471 Reputation points

2023-01-27T22:35:58.55+00:00

Hello,

Go to Settings > Keys in Azure under Cosmos DB.

If this is helpful please accept answer.
Please sign in to rate this answer.
Shittu Adesoji (NHQ-AC-CONSULTANT) 5 Reputation points

2023-01-30T13:37:46.04+00:00

Thank you for response. That is a valid answer but still the question remains why is the linkedservice still show the error .. despite the fact azure cosmos DB account name see below

Nandan Hegde 29,886 Reputation points MVP

2023-01-30T14:00:10.61+00:00

Do you have access to see the storage account key via portal as stated by Dillon?

It might be due to some access issues

Shittu Adesoji (NHQ-AC-CONSULTANT) 5 Reputation points

2023-01-30T14:15:51.9366667+00:00

I only see the read-only keys within the connection strings menuitem. Also the diagram you presented refers to a cosmos db. account but the one i am reporting is for cosmos dB for mongoDB.

Oury Ba-MSFT 16,156 Reputation points Microsoft Employee

2023-02-04T00:34:55.78+00:00

Hi Shittu Adesoji (NHQ-AC-CONSULTANT)

The issue could be related to your Azure cosmos DB for Mongo DB account.

Could you please test it using the connection string and see the result and also via Data Studio to Azure Cosmos DB.

Regards,

Oury

Oury Ba-MSFT 16,156 Reputation points Microsoft Employee

2023-02-07T21:30:38.86+00:00

Hi Shittu Adesoji (NHQ-AC-CONSULTANT)

This error message usually occurs when the Azure Cosmos DB account is not properly configured, or the service principal used to authenticate the pipeline does not have the necessary permissions to access the storage account. To resolve this issue, you can try the following steps:

Verify that the Azure Cosmos DB account is properly configured and that the service principal used to authenticate the pipeline has the necessary permissions to access the storage account.

Check that the Azure Cosmos DB account is in the same subscription as the storage account.

Check that the Azure Cosmos DB account is in the same region as the storage account.

Check that the Azure Cosmos DB account is in the same resource group as the storage account.

Check that the Azure Cosmos DB account is in the same tenant as the storage account.

Check that the Azure Cosmos DB account is in the same subscription as the storage account.

Please let us know if you are still facing the same issue.

Regards,

Oury

Oury Ba-MSFT 16,156 Reputation points Microsoft Employee

2023-02-15T19:24:25.69+00:00

Hi Shittu Adesoji (NHQ-AC-CONSULTANT)

In addition to my answer above. I would like to thank you for the feedback provided on survey. We found that your recent engagement on this engagement on this question was rated low. Could you please share in more details your experience on this thread and what can we do to improve our answers.

Regard,

Oury
Sign in to comment