> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Use this reference to learn about the metadata available about accounts using the information schema.

# 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.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  *
FROM
  information_schema.accounts;
```

<Note>
  Read more about managing accounts [here](/guides/managing-your-organization/managing-accounts).
</Note>

<Note>
  For account-level settings and flags (for example, enabling LLM features), see
  [information\_schema.account\_info](/reference-sql/information-schema/account_info).
</Note>

## 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.                                          |
| 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 identity this account belongs to.                 |
| last\_altered       | TIMESTAMP | Time (UTC) that the user was last edited.                         |
| last\_altered\_by   | TEXT      | Name of the last user to edit the role.                           |