Retrieve password from Azure key vault in Azure Synapse T sql

Rajib Mandal 26 Reputation points
2022-11-24T10:21:47.26+00:00

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?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,662 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 85,031 Reputation points Microsoft Employee
    2022-11-28T07:39:04.327+00:00

    Hello @Rajib Mandal ,

    Thanks for the question and using MS Q&A platform.

    Unfortunately it is not possible to retrive password from Azure Key Vault in Azure Synapse T-SQL.

    You may checkout the SO thread addressing similar issue.

    There is a third party AzureKeyVault Adapter - This adapter allows you to connect to the Azure KeyVault service and manage secrets.

    Disclaimer: This response contains a reference to a third-party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators
    0 comments No comments

0 additional answers

Sort by: Most helpful