Use this reference to learn about the metadata available for Firebolt logins using the information schema.
You can use the information_schema.logins
view to return information about logins.
You can use a SELECT
query to return information about each login, as shown in the example below.
For more information, see Managing logins.
Each row has the following columns with information about each login.
Column Name | Data Type | Description |
---|---|---|
login_name | TEXT | Name of the login (email address). |
first_name | TEXT | First name of the user linked to the login. |
last_name | TEXT | Last name of the user linked to the login. |
organization_name | TEXT | Name of the organization. |
network_policy_name | TEXT | Name of the network policy associated with the login. |
is_mfa_enabled | BOOLEAN | Specifies if the login has multi-factor authentication enabled. |
is_sso_provisioned | BOOLEAN | Specifies if the login was provisioned with an identity provider defined in the organization’s SSO configuration. |
is_password_enabled | BOOLEAN | Specifies if log in with password is enabled. |
is_organization_admin | BOOLEAN | Specifies if the login is an organization admin. |
is_enabled | BOOLEAN | Specifies if the login is allowed to authenticate. |
created | TIMESTAMPTZ | Time the login was created. |
login_owner | TEXT | The name of the identity to whom this login belongs. |
last_altered | TIMESTAMPTZ | Time the login was last altered. |
last_altered_by | TEXT | Name of the login who edited the login. If the login was edited by a service account, the service account name appears instead. |