Information schema for service_accounts

You can use the information_schema.service_accounts view to return information about service accounts. You can use a SELECT query to return information about each service account as shown in the example below.

SELECT
  *
FROM
  information_schema.service_accounts;

Read more about service accounts here.

Columns in information_schema.service_accounts

Each row has the following columns with information about a service account.

Column Name Data Type Description
service_account_id TEXT The ID of the service account.
service_account_name TEXT The name of the service account.
network_policy_name TEXT The name of the network policy used by this service account.
service_account_description TEXT The description of the service account.
is_organization_admin BOOLEAN Specifies if the service account is an organization admin.
is_enabled BOOLEAN Specifies if the service account is allowed to authenticate.
created TIMESTAMPTZ Time of the service account creation.
service_account_owner TEXT The name of the login that created the service account. If the service account was created by a service account, the service account name appears instead.
last_altered TIMESTAMPTZ Time the service account was last altered.
last_altered_by TEXT The name of the login that edited the service account. If the service account was edited by a service account, the service account name appears instead.