Control: Use Tri-Secret Secure
Description
Tri-Secret Secure is the combination of a Snowflake-maintained key and a customer-managed key in the cloud provider platform that hosts your Snowflake account to create a composite master key to protect your Snowflake data. The composite master key acts as an account master key and wraps all of the keys in the hierarchy.
Usage
Run the control in your terminal:
powerpipe control run snowflake_compliance.control.security_overview_data_encryption_use_tri_secret_secureSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run snowflake_compliance.control.security_overview_data_encryption_use_tri_secret_secure --shareSQL
This control uses a named query:
select account as resource, 'info' as status, 'Manual verification required.' as reason, accountfrom snowflake_userlimit 1;