question

AzureLearner-2905 avatar image
0 Votes"
AzureLearner-2905 asked RodrigoSouza-0745 answered

Unable to see CosmosDb database containers under the Linked service in Syanpase Studio.

I have connected the CosmosDB which is in another subscription. I am able to connect the CosmosDB as a Linked service in Synapse Workspace but unable to see any containers. Is there any settings I must check.

On the other hand I am unable to execute T-SQL query. It is resulting in error: Resolving CosmosDB path has failed with error 'This request is not authorized to perform this operation.'.

Please help me. Thank you for the support.

azure-synapse-analyticsazure-cosmos-db
· 10
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.

Hi @AzureLearner-2905, welcome to Microsoft Q&A forum.

II tried using below article and was able to successfully see the container belong to a database in Azure Cosmos Account SQL API.

Quickstart: Connect to Azure Synapse Link for Azure Cosmos DB

If possible, could you please share the screenshot of synapse studio and linked service? Also please provide the screenshot of error message as well.

0 Votes 0 ·

Than you and this is the error I am getting.
115115-error.png


0 Votes 0 ·
error.png (51.0 KiB)
error.png (63.5 KiB)

Hi @AnuragSharma-MSFT , I tried to run the query for another db and container but getting the same error: "This request is not authorized to perform this operation"

0 Votes 0 ·

Hi @AnuragSharma-MSFT I am using a Free trail of Azure and the cosmosDB is under different subscription.

0 Votes 0 ·
Show more comments

@AnuragSharma-MSFT - I am getting the same error. I don't see any firewall restrictions as well.

0 Votes 0 ·

@AnuragSharma-MSFT - In my case the issue was because synapse and cosmos was on different regions

0 Votes 0 ·

1 Answer

RodrigoSouza-0745 avatar image
0 Votes"
RodrigoSouza-0745 answered

Cross tennat access isn't supported in the Linked Service tree view. You can query it, but you won't see the containers.

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.