CODEWITHSUNDEEP
azure-sql-databaseazure-synapse
Bradley Yoo
Bradley Yoo

Reputation: 1

Azure SQL Data Warehouse Node to Node Encryption

would like to know if there's any encryption in Azure SQL Data Warehouse particularly around inter-node communications during query transits?
If so, could someone help direct me to the page with more info about it?

Upvotes: 0

Views: 51

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

Azure SQL Data Warehouse has the encryption called Transparent data encryption.

You can use Transparent data encryption for your Azure SQL data Warehouse.

Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Data Warehouse against the threat of malicious offline activity by encrypting data at rest. It performs real-time encryption and decryption of the database, associated backups, and transaction log files at rest without requiring changes to the application. By default, TDE is enabled for all newly deployed Azure SQL databases.

TDE needs to be manually enabled for older databases of Azure SQL Database, Azure SQL Managed Instance, or Azure SQL Data Warehouse.

For more details, please see: Transparent data encryption for SQL Database and Data Warehouse.

Reference tutorials:

  1. Portal: Get started with Transparent Data Encryption (TDE) in SQL Data Warehouse
  2. T-SQL: Get started with Transparent Data Encryption (TDE)

Hope this helps.

Upvotes: 0

Related Questions