Share via

What is the alternative of DECRYPTBYKEYAUTOCERT in Azure Synapse ?

Anonymous
2023-12-01T14:31:46.79+00:00

I used to work with TSQL and it is possible to use DECRYPTBYKEYAUTOCERT inside VIEW.

Now I am using Synapse SQL and I am new to it, in this case how to retrieve decrypted value from a view?

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.
5,384 questions
0 comments
Accepted answer
  1. Amira Bedhiafi 34,651 Reputation points Volunteer Moderator
    2023-12-01T14:48:12.9566667+00:00

    DECRYPTBYKEYAUTOCERT is not supported in Azure Synapse.

    You need to use :

    • DecryptByKeyAutoCert
    • DecryptByKeyAutoAsymKey
    • DecryptByPassphrase

    Check this old thread : https://stackoverflow.com/questions/73960490/decryptbykeyautocert-in-azure-synapse

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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