Table: keycloak_idp
Obtain information on Identity Providers configured against the current realm.
Examples
List all Identity Providers
select *from keycloak_idp;
List only enabled Identity Providers
select *from keycloak_idpwhere enabled = true;
List only OIDC Identity Providers
select *from keycloak_idpwhere provider = 'oidc';
Schema for keycloak_idp
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
alias | text | Alias (human-friendly id) for the Identity Provider | |
display_name | text | Friendly display name for the Identity Provider | |
enabled | boolean | Indicates if the Identity Provider is enabled | |
id | text | Unique identifier for the Identity Provider | |
initial_login_flow | text | Alias of authentication flow performed after the first login from this Identity Provider where a Keycloak account does not exist yet. | |
normal_login_flow | text | Alias of authentication flow performed after the subsequent login from this Identity Provider where a Keycloak account exists. | |
provider | text | Provider identifier/type (saml/oidc/etc). | |
store_token | boolean | Indicates if the token must be stored after user authentication | |
trust_email | boolean | Indicates if the emails provided by the Identity Provider are trusted and do not require verification |