CREDENTIALS view¶

Type of the credential. These types include:

• PASSKEY: Passkey.
• PAT: Programmatic access token.
• TOTP: Time-based one-time passcode.
• AWS: AWS Identity and Access Management (AWS IAM) is the identity provider, which indicates the workload is running on AWS. See Workload identity federation.
• AZURE: Microsoft Entra ID is the identity provider, which indicates the workload is running on Microsoft Azure. See Workload identity federation.
• GCP: Google Accounts is the identity provider, which indicates the workload is running on Google Cloud. See Workload identity federation.
• OIDC: An OpenID Connect (OIDC) provider is the identity provider. See Workload identity federation.
• KEYPAIR: Key pair.

Domain of the credential. The domains include:

• MFA_METHOD: The credential is used as a second factor of authentication.
• PROGRAMMATIC_ACCESS_TOKEN: Programmatic access token.
• WORKLOAD_IDENTITY_FEDERATION_METHOD: Workload identity federation.
• KEYPAIR: Key pair.

A given domain can have one or more possible types (specified in the TYPE column).

Status of the credential. The status depends on the value in the TYPE column:

• For TYPE = 'PAT' (programmatic access tokens), the status can be one of the following:

• For TYPE = 'KEYPAIR' (key pairs), the status can be one of the following:

• For other types of credentials, the status can be one of the following:
  • PENDING: The user started the enrollment process for an MFA method but has not completed the process. For example, the user started registering an authenticator but never finished the setup process for the authenticator. As a result, the MFA method is not considered to be valid yet.
  • ENROLLED: The user has completed the enrollment process for the MFA method, and the MFA method can be used for second-factor authentication.

Additional details about the credential. The additional details depend on the type of the credential (the value in the TYPE column):

• For TYPE = 'PAT' (programmatic access tokens), the column contains an OBJECT value with the following key-value pairs:
  • For the MINS_TO_BYPASS_NETWORK_POLICY_REQUIREMENT key, the value is an integer representing the number of minutes during which the requirement of having a network policy is bypassed. You can specify this value when generating the token.
  • For the ROLE_RESTRICTION key, the value is an array of the roles that are used for privilege evaluation and object creation during the session authenticated with this token. You can specify these roles when generating the token.
  • For the ROTATED_TO key, the value is the name of the newer token that this token was replaced by during rotation.

These key-value pairs are present only if the corresponding properties are set in the token. For example:

{
  "MINS_TO_BYPASS_NETWORK_POLICY_REQUIREMENT": 60,
  "ROLE_RESTRICTION": ["MY_ROLE"],
  "ROTATED_TO": "MY_PAT_NAME"
}

If none of these are specified for the token, the column contains an empty object ({}).

• For TYPE = 'PASSKEY' (passkey), the column contains an OBJECT value with the key-value pair aaguid. For example:

{
  "aaguid": "a12345678-..."
}

• For TYPE = 'TOTP' (time-based one-time passcode), the column contains NULL.

• For TYPE = 'AWS' (workload identity federation), the column contains an OBJECT value with the following key-value pairs:

  • For the aws_partition key, the value is the AWS partition for the federated identity.
  • For the aws_account key, the value is the AWS account identifier for the federated identity.
  • For the type key, the value is the type of the federated identity. This can be IAM_USER or IAM_ROLE.
  • For the iam_role key, the value is the name of the federated IAM role or user.

• For TYPE = 'AZURE' (workload identity federation), the column contains an OBJECT value with the following key-value pairs:

  • For the issuer key, the value is the Entra ID tenant’s Authority URL.
  • For the subject key, the value is the Object ID (Principal ID) assigned to the Azure workload that is using a managed identity.

• For TYPE = 'GCP' (workload identity federation), the column contains an OBJECT value with the following key-value pairs:

  • For the subject key, the value is the uniqueId property of the Google Cloud service account associated with the federated workload.

• For TYPE = 'OIDC' (workload identity federation), the column contains an OBJECT value with the following key-value pairs:

  • For the issuer key, the value is the issuer URL of the OpenID Connect (OIDC) provider.
  • For the subject key, the value is the identifier of the federated workload.
  • For the audience_list key, the value is the custom audiences that are allowed in an OIDC ID token. An empty value means the default audience snowflakecomputing.com is required.

• For TYPE = 'KEYPAIR' (key pair), the column contains an OBJECT value with the following key-value pairs:

  • For the KEY_TYPE key, the value is the algorithm of the key pair (for example, RSA).
  • For the PUBLIC_KEY_FP key, the value is the SHA-256 fingerprint of the public key.