Data Factory Set variable with KeyVault Value

user_14170289 0
Viewed 1777

How can I set a variable with the value that I have stored in a KeyVault secret?

azure-data-factory-pipeline azure-data-factory
1 Answers

Update:
Hi @willy sepulveda. We only can secure the input and output in Web Activity,like follows:
enter image description here Input and output data will be sensitive:
enter image description here

You can use Web activity to access the Key Valut value. Refer this documentation. I also created a test.

  1. Open the properties of your data factory and copy the Managed Identity Object ID value. Open the key vault access policies and add the managed identity permissions to Get and List secrets.
    enter image description here

  2. Then I created a secret named myKey and set the value helloworld.

Note: The name of the secret (myKey) will be used below at Step 5. enter image description here

  1. Declare a String type variable named myVar in ADF pipeline. enter image description here

  2. In Web1 activity, select Sceure output. enter image description here

  3. Web1 activity settings
    URL: https://<your-keyvalut-name>.vault.azure.net/secrets/<your-secret-name>?api-version=7.0.

You need replace keyvalut name and secret name.

Authentication: Select Managed Identity.
Resource: Enter https://vault.azure.net. enter image description here

  1. In Set variable1 activity, add dynamic content @activity('Web1').output.value. enter image description here

  2. Debug result: I can see that the variable successfully received the secret value. enter image description here

user_139794870
Related