Policy: Azure > SQL > Database > Encryption at Rest

Define the Encryption at Rest settings required for Azure > SQL > Database.

Encryption at Rest refers specifically to the encryption of data when written to an underlying storage system. This control determines whether the resource is encrypted at rest, and sets encryption.

The Encryption at Rest control compares the encryption settings against the encryption policies for the resource (Azure > SQL > Database > Encryption at Rest), raises an alarm, and takes the defined enforcement action.

Resource Types

This policy targets the following resource types:

Azure > SQL > Database

Controls

Azure > SQL > Database > Encryption at Rest

Policy Packs

This policy setting is used by the following policy packs:

Azure CIS v2.0.0 - Section 4 - Database Services

Policy Specification

Schema Type	`string`
Default	`Skip`
Valid Values [YAML]	`Skip` `Check: Enabled` `Check: Disabled` `Enforce: Enabled` `Enforce: Disabled`
Examples [YAML]	`Skip`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/resourceEncryptionAtRest

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/databaseEncryptionAtRest

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/databaseEncryptionAtRest") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseEncryptionAtRest'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseEncryptionAtRest'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/databaseEncryptionAtRest"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/databaseEncryptionAtRest"