Schema:

ORGANIZATION_USAGE

For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).

TRI_SECRET_SECURE_HISTORY view

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

Organization Usage performance

When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in Performance (Organization Usage): bound every scan on history views, list columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.

This Organization Usage view provides information about Tri-Secret Secure customer-managed keys (CMKs) for accounts in your organization within the last year (365 days).

Columns

Organization-level columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization.
ACCOUNT_LOCATORVARCHARSystem-generated identifier for the account.
ACCOUNT_NAMEVARCHARUser-defined identifier for the account.

Additional columns

Column nameData typeDescription
IDNUMBERSystem-generated ID that uniquely identifies a CMK used in the account.
REGISTERED_BY_USER_IDNUMBER

Identifies the user who registered the CMK. Also appears in the ACCOUNT_USAGE view if a customer self-registered the CMK.

CMK_ACTIVATION_STATUSVARCHAR

Activation status of the CMK. Valid values are:

  • PENDING_ACTIVATION
  • ACTIVATED
  • PENDING_DEACTIVATION
  • DISABLED
CMK_IDENTIFIERVARCHAR

Displays a value that you can use to locate your customer managed key. For example:

  • AWS: key ARN
  • Azure: https://mykeyvault.vault.azure.com/keys/my-rsa-key
  • Google Cloud: projects/PROJECT_ID/locations/LOCATION/keyRings/KEY_RING/cryptoKeys/KEY_NAME
IS_REGISTEREDBOOLEANWhether the key represented by the CMK identifier is registered or not.
REGISTERED_ONTIMESTAMP_LTZIdentifies the last time when a user registered the CMK.
ACTIVATED_ONTIMESTAMP_LTZIdentifies the last time when a user activated the CMK.
DISABLED_ONTIMESTAMP_LTZIdentifies the last time when a user disabled the CMK.
UPDATED_ONTIMESTAMP_LTZIdentifies the time of the last update to this view.

Usage notes

  • Latency for the view may be up to 24 hours.
  • This view only returns rows for accounts with the Business Critical or Virtual Private Snowflake (VPS) service level.

Examples

Retrieve all Tri-Secret Secure history records for accounts in your organization:

SELECT * FROM SNOWFLAKE.ORGANIZATION_USAGE.TRI_SECRET_SECURE_HISTORY;