Lists service principals in the catalog, optionally filtered by a LIKE pattern.
SHOW SERVICE PRINCIPALS [LIKE '<pattern>']## Overview SHOW SERVICE PRINCIPALS returns a row per service principal with its name, application id (if managed by an external identity provider), disabled flag, and creation timestamp. ## Access Control Requires the `ManageUsers` privilege. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
pattern | Optional LIKE pattern. |
SHOW SERVICE PRINCIPALS;SHOW SERVICE PRINCIPALS LIKE 'etl_%';