I'm using ADF dataflow to process data from CosmosDB. Is there a way to auto update the connection key in linked service when the cosmosDB keys are rotated ?
CodePudding user response:
based on my understanding unfortunately it is not possible directly. What you can do is have a custom logic via azure automation or any tool to rotate the keys and push the keys to the key vault when rotated. And you can map the linked service in adf ti fetch from key vault rather than manually updating it
CodePudding user response:
I would recommend you consider authenticating using the Data Factory Managed Service Identity. This approach avoids having to manage any passwords or keys and is the preferred approach from a security best practice.