---

SELECT
    json::jsonb
        -> 'ldapConfiguration'
        ->> 'authRolesMapping' AS auth_roles_mapping
FROM openmetadata_settings
WHERE configtype = 'authenticationConfiguration';