> ## 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 service accounts using the information schema.

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

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

For more information about service accounts, see [Manage programmatic access to Firebolt](/guides/managing-your-organization/service-accounts).

## 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](/managed-service/organizations-accounts#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](/managed-service/organizations-accounts#organizational-administrative-role) can configure this setting, and it can be modified after creation. Available options include the following: <br /> - **`PUBLIC_ONLY`**: Allows access only through the public internet. <br /> - **`PRIVATE_ONLY`**: Allows access only using AWS PrivateLink. <br /> - **`PREFER_PUBLIC`** (Default): Prefers the public internet but calls that do reach Firebolt via AWS PrivateLink won't be explicitly rejected. <br /> - **`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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |