Get started with Transparent Data Encryption (TDE) in SQL Data Warehouse

Required Permssions

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

Enabling Encryption

To enable TDE for a SQL Data Warehouse, 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
  4. Select the On setting
  5. Select Save

Disabling Encryption

To disable TDE for a SQL Data Warehouse, 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
  4. Select the Off setting
  5. Select Save

Encryption DMVs

Encryption can be confirmed with the following DMVs: