Categories:

System Functions (System Information)

SYSTEM$GET_CMK_KMS_KEY_POLICY¶

Returns an ARRAY containing a snippet of the AWS Key Management Service policy information related to customer-managed keys for use with Tri-Secret Secure for Snowflake accounts on Amazon Web Services.

See also:

Understanding Encryption Key Management in Snowflake

Syntax¶

SYSTEM$GET_CMK_KMS_KEY_POLICY()
Copy

Arguments¶

None.

Usage Notes¶

  • This function is for use in Snowflake accounts on Amazon Web Services only.

  • Only account administrators (i.e. users with the ACCOUNTADMIN role) or a role that is granted the MONITOR SECURITY privilege can call this function.

Examples¶

Return a snippet of the AWS KMS policy for use with customer-managed keys and Tri-Secret Secure:

SELECT SYSTEM$GET_CMK_KMS_KEY_POLICY();
Copy