Service accounts

Use the information_schema.service_accounts view to return information about service accounts. The following code example uses a SELECT query to return information about each service account:

SELECT
  *
FROM
  information_schema.service_accounts;

For more information about service accounts, see Manage programmatic access to Firebolt.

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.
description	TEXT	The description of the service account.
is_organization_admin	BOOLEAN	Specifies if the user associated with the service account has an organizational administrative role.
connection_preference	TEXT	Defines the connectivity preference for a service account. The default value is `PREFER_PUBLIC` if not specified. A user with an organizational administrator role can configure this setting, and it can be modified after creation. Available options include the following: - `PUBLIC_ONLY`: Allows access only through the public internet. - `PRIVATE_ONLY`: Allows access only using AWS PrivateLink. - `PREFER_PUBLIC` (Default): Prefers the public internet but calls that do reach Firebolt via AWS PrivateLink won’t be explicitly rejected. - `PREFER_PRIVATE`: Prefers AWS PrivateLink but calls that do reach Firebolt via the public internet won’t be explicitly rejected.
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 identity to whom this service account belongs.
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.

Schemata

Streams

⌘I

What is Firebolt?

Overview

Self-Managed

Performance and Observability

Guides

SQL reference

General reference

API reference

Legal

Columns in information_schema.service_accounts

​Columns in information_schema.service_accounts

Columns in information_schema.service_accounts