Azure synapse TDE

sakuraime 2,331 Reputation points
2021-11-17T09:48:44.307+00:00

Is it possible to change the Database encryption key ,instead of just rotate the key encryption key (the key in the keyvault) ??

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,172 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2021-11-18T06:49:41.707+00:00

    Hi @sakuraime ,

    Thanks for your query.

    ALTER Database encryption key is not supported for Azure SQL/Azure Synapse. Please see below note form public documentation.

    150502-image.png

    Ref doc: ALTER DATABASE ENCRYPTION KEY (Transact-SQL)

    Hope this answers your query.

    ----------

    • Please don't forget to click on 130616-image.png and 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 how you can be part of Q&A Volunteer Moderators

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.