steampipe plugin install theapsgroup/keycloak

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_idp
where
enabled = true;

List only OIDC Identity Providers

select
*
from
keycloak_idp
where
provider = 'oidc';

Schema for keycloak_idp

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
aliastextAlias (human-friendly id) for the Identity Provider
display_nametextFriendly display name for the Identity Provider
enabledbooleanIndicates if the Identity Provider is enabled
idtextUnique identifier for the Identity Provider
initial_login_flowtextAlias of authentication flow performed after the first login from this Identity Provider where a Keycloak account does not exist yet.
normal_login_flowtextAlias of authentication flow performed after the subsequent login from this Identity Provider where a Keycloak account exists.
providertextProvider identifier/type (saml/oidc/etc).
store_tokenbooleanIndicates if the token must be stored after user authentication
trust_emailbooleanIndicates if the emails provided by the Identity Provider are trusted and do not require verification