Categories:

System functions (System Information)

SYSTEM$GET_CMK_INFO_POSTGRES

Returns the status of your customer-managed key (CMK) for use with Snowflake Postgres Tri-Secret Secure. Information is returned only for currently registered and activated keys.

语法

SYSTEM$GET_CMK_INFO_POSTGRES()

返回

Returns a status message indicating the state of your CMK. The output includes the values that you specified when calling SYSTEM$REGISTER_CMK_INFO_POSTGRES.

The following messages are possible, using CMKs on Amazon Web Services as a representative example:

  • Your CMK is registered, but not yet enabled, to use Snowflake Postgres Tri-Secret Secure:

    CMK with ARN: arn:aws:kms:us-west-2:736112632310:key/ceab36e4-f0e5-4b46-9a78-86e8f17a0f59
is pre-registered for Tri-Secret Secure.

  • Your CMK is activated and in use with Snowflake Postgres Tri-Secret Secure:

    CMK with ARN: arn:aws:kms:us-west-2:736112632310:key/ceab36e4-f0e5-4b46-9a78-86e8f17a0f59
is activated for Tri-Secret Secure.

  • 您有一个活动 CMK，但您刚刚预注册了一个新密钥：

    CMK with ARN: arn:aws:kms:us-west-2:736112632310:key/ceab36e4-f0e5-4b46-9a78-86e8f17a0f59
is activated with Tri-Secret Secure, but
CMK with ARN: arn:aws:kms:us-west-2:481048248138:key/e08cb6c0-7c09-4f37-8e55-e395a12fe965
is pre-registered for Tri-Secret Secure.

  • You have an active key, but have not registered any CMK to use Snowflake Postgres Tri-Secret Secure:

    CMK info has not been pre-registered in this account yet, but
CMK arn:aws:kms:us-west-2:736112632310:key/ceab36e4-f0e5-4b46-9a78-86e8f17a0f59
is activated with Tri-Secret Secure.

  • You have not registered any CMK to use Snowflake Postgres Tri-Secret Secure:

    CMK info has not been pre-registered in this account yet.

访问控制要求

只有账户管理员（具有 ACCOUNTADMIN 角色的用户）或被授予账户 MONITOR SECURITY 权限的角色才能调用此函数。

示例

获取 Snowflake 账户的状态 CMK：

SELECT SYSTEM$GET_CMK_INFO_POSTGRES();