Get started with Transparent Data Encryption (TDE) for dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics

Required Permissions

To enable Transparent Data Encryption (TDE), you must be an administrator or a member of the dbmanager role.

Enabling Encryption

To enable TDE, follow the steps below:

  1. Open the database in the Azure portal
  2. In the database blade, click the Settings button
  3. Select the Transparent data encryption option portal settings
  4. Select the On setting portal settings on
  5. Select Save portal settings save

Disabling Encryption

To disable TDE, follow the steps below:

  1. Open the database in the Azure portal
  2. In the database blade, click the Settings button
  3. Select the Transparent data encryption option portal settings
  4. Select the Off setting portal settings off
  5. Select Save portal setting save 2

Encryption DMVs

Encryption can be confirmed with the following DMVs: