How to configure a linked service to Cosmos DB (SQL API) with a linked service to Azure Key Vault with parameterized database

DevWeb 6 Reputation points
2022-10-07T22:23:12.797+00:00

With Azure Data Factory UI experience, one can create a linked service to Cosmos DB (SQL API) with a linked service to Azure Key Vault using the Account Key type authentication. In this particular scenario, we have added secrets to the Azure Key Vault for the Cosmos DB connection string but we do not want the connection string to include "Database=xxx" as we would like to parameterize that so that we do not have to add connection strings for each Cosmos DB databases to the key vault. Unfortunately, the UI does not offer any option for us to specify "Database=xxx" to the Cosmos DB-linked service using Azure Key Vault. You can switch to use Connection String mode, but then one would have to pass in Cosmos DB Uri and then use the access key from Azure Key Valut secret. Do we have any option here using a linked service to Azure Key Vault to construct a linked service to Cosmos DB with a parameter for the Database name?

248614-image.png

248615-image.png

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    2 deleted comments

    Comments have been turned off. Learn more

Your answer

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