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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/information-schema/accounts",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> 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":"github-light","dark":"github-dark"}}
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.                           |