0

I have created certificate in synapse with below code. I want to retrieve password from azure key vault and use the password in the below statement.

CREATE CERTIFICATE ZZZZ_Certificate ENCRYPTION BY PASSWORD = 'pGFD4bb925DGvbd2439587y' WITH SUBJECT = 'ZZZ Information', EXPIRY_DATE = '20221231';

I went through MSFT document and did not find anything. Is it possible to retrieve secret information from Azure key vault and use them in T SQL in synapse?

Regards, Rajib

Rajib
  • 19
  • 1
  • 7

1 Answers1

1

"I want to retrieve the password from Azure Key Vault and use it in the below statement.

For the time being, you can retrieve the credentials from the Azure Key Vault but not use them to generate a certificate.

and here is the reference document for my answer.

I want to retrieve password from azure key vault and use the password in the below statement.

If you want to retrieve credentials from the Azure Key Vault, try to follow this reference. enter image description here enter image description here reference link for Use Azure Key Vault secrets in pipeline activities

vijaya
  • 1,525
  • 1
  • 2
  • 6
  • Hi @vijaya,Thanks for your response.My requirement is to retrieve key vault infromatio from synapse T sql.Is it possible to retrieve from keyvault secret from T SQL Statement? – Rajib Nov 28 '22 at 06:02
  • Hi @Rajib, My pleasure. As shown in synapse workspace image you can retrieve it but the problem is you want to use that password in Certificate. So that's what i am trying to say for the time being you can retrieve but not use them to generate a certificate. – vijaya Nov 30 '22 at 03:08