> ## 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](/managed-service/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#firebolt-built-in-roles). |
| 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#firebolt-built-in-roles) 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. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.