Information schema for accounts

You can use the information_schema.accounts view to return information about accounts.

You can use a SELECT query to return information about each account, as shown in the example below.

SELECT
  *
FROM
  information_schema.accounts;

Read more about managing accounts here.

Columns in information_schema.accounts

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

Column Name	Data Type	Description
account_name	TEXT	The name of the account.
organization_name	TEXT	The name of the organization to which the account belongs.
region	TEXT	The region in which the account can be used.
url	TEXT	The account login page URL.
account_id	TEXT	The unique account ID.
trust_policy_role	TEXT	Role provided by Firebolt to enable access to customer S3 buckets
created	TIMESTAMP	Time (UTC) that the account was created.
account_owner	TEXT	The name of the login that created the account.
last_altered	TIMESTAMP	Time (UTC) that the user was last edited.
last_altered_by	TEXT	Name of the last user to edit the role.