You can use the
information_schema.service_accounts view to return information about service accounts. You can use a
SELECT query to return information about each service account as shown in the example below.
Read more about service accounts here.
Each row has the following columns with information about a service account.
|The ID of the service account.
|The name of the service account.
|The name of the network policy used by this service account.
|The description of the service account.
|Specifies if the service account is an organization admin.
|Time of the service account creation.
|The name of the login that created the service account. If the service account was created by a service account, the service account name appears instead.
|Time the service account was last altered.
|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.