> ## 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/service-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 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":"github-light","dark":"github-dark"}}
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](/overview/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](/overview/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 public APIs. <br /> - **`PRIVATE_ONLY`**: Allows access only using AWS PrivateLink. <br /> - **`PREFER_PUBLIC`** (Default): Prefers public APIs but can use AWS PrivateLink if needed. <br /> - **`PREFER_PRIVATE`**: Prefers AWS PrivateLink but can use public APIs if needed. |
| 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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |