> ## Documentation Index > Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt > Use this file to discover all available pages before exploring further. # Google SSO Configuration Guide | Confidential Client Setup > Comprehensive guide to setting up Google SSO for confidential clients using OIDC. Includes client secret configuration, secure token handling, and advanced security options. # Google SSO Configuration (Confidential Client) * [Troubleshooting](#troubleshooting) Google Single Sign-On (SSO) enables users to log in with their Google Workspace accounts using OAuth 2.0 and OpenID Connect (OIDC). This configuration covers the **Confidential Client** setup, intended for web applications and backend services that can securely store credentials. ## Overview Collate supports Single Sign-On (SSO) integration with various identity providers, enabling secure, centralized user authentication. 1. Navigate to **Settings** > **SSO**. SSO Authentication 2. Select the service provider. Supported Providers 3. Click **Configure** to set up Single Sign-On (SSO). See [Confidential Configuration Fields](#confidential-configuration-fields). Google SSO Configuration - Confidential Client 4. Click **Save** to finish the SSO configuration. ## Confidential Configuration Fields This section lists all fields in the order they appear in the Collate SSO configuration form. ### Authentication Configuration Configure the identity provider connection and basic authentication behavior. #### Provider Name * **Definition**: A human-readable name for this Google SSO configuration instance. * **Example**: `Google SSO`, `Company Google SSO`, `Google Workspace` * **Why it matters**: Helps identify this specific SSO configuration in logs and user interfaces. * **Note**: This is a display name and doesn't affect authentication functionality. #### Client Type * **Definition**: Defines whether the application is public (no client secret) or confidential (requires client secret). * **Options**: Public | Confidential * **Example**: Confidential * **Why it matters**: Determines security level and authentication flow. Confidential clients can securely store secrets. * **Note**: * Use `Confidential` for backend services and web applications. * Use `Public` for SPAs and mobile apps. * Google typically uses **Confidential** client type. #### Enable Self Signup * **Definition**: Allows users to automatically create Collate accounts on their first SSO login. * **Options**: Enabled | Disabled * **Example**: Enabled * **Why it matters**: Controls whether new users join automatically or need manual provisioning. * **Note**: Disable for stricter control over user access. #### Authority * **Definition**: Google's authorization server endpoint for OAuth 2.0 authentication. * **Default**: `https://accounts.google.com` * **Why it matters**: Specifies the Google authorization server that handles authentication requests. * **Note**: This is Google's standard OAuth 2.0 authorization endpoint and typically doesn't need to be changed. ### OIDC Configuration Configure the OIDC client credentials and token handling; these fields appear when **Client Type** is set to **Confidential**. #### OIDC Client ID * **Definition**: OAuth 2.0 client ID assigned to your application in Google Cloud Console. * **Example**: `123456789012-abcdefghijklmnopqrstuvwxyz123456.apps.googleusercontent.com` * **Why it matters**: Identifies your application to Google in OIDC flows. * **Note**: Found in **Google Cloud Console** > **APIs & Services** > **Credentials** > **OAuth 2.0 Client IDs**. #### OIDC Client Secret * **Definition**: Secret key for confidential client authentication with Google. * **Example**: `GOCSPX-abcdefghijklmnopqrstuvwxyz123456` * **Why it matters**: Required for confidential clients to securely authenticate with Google. * **Note**: * Generate in **Google Cloud Console** > **APIs & Services** > **Credentials**. * Store securely and rotate regularly. #### OIDC Request Scopes * **Definition**: Permissions requested from Google during authentication. * **Default**: `openid email profile` * **Example**: `openid email profile https://www.googleapis.com/auth/userinfo.email` * **Why it matters**: Determines what user information Collate can access. * **Note**: `openid`, `email`, and `profile` are required for basic user identification. #### OIDC Discovery URI * **Definition**: Google's OpenID Connect metadata endpoint. * **Default**: `https://accounts.google.com/.well-known/openid-configuration` * **Why it matters**: Allows Collate to automatically discover Google's OIDC endpoints. * **Note**: Google's standard discovery endpoint — rarely needs to be changed. #### OIDC Callback URL * **Definition**: URL where Google redirects after authentication. * **Example**: `https://openmetadata.company.com/callback` * **Why it matters**: Must be registered in your Google Cloud Console configuration. * **Note**: * **This field is read-only** — it is auto-populated as `{your-domain}/callback`. * Copy this URL and add it to **Google Cloud Console** > **OAuth 2.0 Client** > **Authorized redirect URIs**. #### OIDC Prompt * **Definition**: Controls Google's authentication prompt behavior. * **Options**: `none`, `login`, `consent`, `select_account` * **Example**: `select_account` * **Why it matters**: Defines how the login experience behaves for users. * **Note**: * `login`: Always prompt for credentials. * `consent`: Prompt for permissions. * `select_account`: Show account picker. * `none`: Silent authentication (may fail if user isn't logged in). #### OIDC Custom Parameters * **Definition**: Additional parameters to include in OIDC authentication requests. * **Example**: `{"hd": "company.com", "prompt": "select_account"}` * **Why it matters**: Allows customization of Google authentication behavior. * **Note**: * `hd`: Hosted domain — restricts login to a specific Google Workspace domain. * `prompt`: Controls authentication prompts. * `login_hint`: Pre-fills the email address field. #### Advanced Configuration The following fields are grouped under **Advanced Config** in the UI (collapsed by default): ##### OIDC Use Nonce * **Definition**: Security feature to prevent replay attacks in OIDC flows. * **Default**: `false` * **Why it matters**: Enhances security by ensuring each authentication request is unique. ##### OIDC Disable PKCE * **Definition**: Whether to disable Proof Key for Code Exchange. * **Default**: `false` * **Why it matters**: PKCE adds security to the authorization code flow. * **Note**: Should remain `false` (enabled) in most cases. ##### OIDC Max Clock Skew * **Definition**: Maximum allowed time difference in seconds between systems when validating tokens. * **Example**: `0` * **Why it matters**: Prevents token validation failures due to minor clock differences between servers. ##### OIDC Token Validity * **Definition**: Duration in seconds that tokens remain valid. * **Default**: `3600` * **Example**: `3600` * **Why it matters**: Balances token lifetime against security requirements. ##### OIDC Max Age * **Definition**: Maximum authentication age in seconds before re-authentication is required. * **Example**: `3600` * **Why it matters**: Controls how frequently users must re-authenticate. ##### OIDC Session Expiry * **Definition**: How long user sessions remain valid in seconds. * **Default**: `604800` (7 days) * **Why it matters**: Controls session timeout for confidential clients. ### JWT Claims Map identity token claims to Collate user identities and team assignments. #### JWT Principal Claims * **Definition**: JWT fields used to identify users in Collate. The first claim that returns a value is used. * **Default**: `["email", "preferred_username", "sub"]` * **Example**: `["email", "sub", "preferred_username"]` * **Why it matters**: Determines how users are matched to their Collate accounts. * **Note**: * At least one claim must correspond to the user's **email address**. * Common Google claims: `email` (recommended), `sub`, `preferred_username`. * Order matters — the first matching claim is used. **Important**: Incorrect claims will lock out all users including admins. The default values (`email`, `preferred_username`, `sub`) work for most Google configurations. Only change if you have custom claim requirements. #### JWT Principal Claims Mapping **Definition**: Maps JSON Web Token (JWT) claims to Collate user profile fields. **Supported keys**: Only `email` and `username` are valid mapping targets in `jwtPrincipalClaimsMapping`. **Example**: ```yaml theme={null} ["email:email", "username:preferred_username"] ``` **Why it matters**: Controls how SSO login data maps to user profiles in Collate. **Format**: `collate_field:jwt_claim` (for example, `"email:email"`). **Note**: The display name is derived automatically from standard OIDC/JWT claims — you don't need to configure it using `jwtPrincipalClaimsMapping`. If you need richer name handling, make sure Google Workspace is configured to include `given_name` and `family_name` as claims in the ID token — Collate will pick them up automatically. **Important**: Using any other key (for example, `name` or `firstName`) will cause the service to fail on startup with a validation error. JWT Principal Claims Mapping is **rarely needed** — the default JWT Principal Claims handle user identification correctly for most Google configurations. #### JWT Team Claim Mapping * **Definition**: Google Workspace claim containing team or department information for automatic team assignment in Collate. * **Example**: `department`, `groups`, `organizationalUnit` * **Why it matters**: Automatically assigns users to existing Collate teams based on their Google Workspace attributes at login. * **Note**: * Common custom attributes can be configured in **Google Admin Console**. * For group-based teams, use the `groups` claim (requires appropriate OAuth scopes). * The team must already exist in Collate for assignment to work. * Only teams of type **Group** can be auto-assigned. Team names are case-sensitive. ### Authorizer Configuration Control which users and domains are permitted to access Collate. #### Admin Principals * **Definition**: Users granted admin access in Collate. * **Example**: `["admin", "superuser"]` * **Why it matters**: Grants full admin privileges in Collate. * **Note**: Enter **usernames only — not email addresses**. Use the part of the email before `@` (for example, for `admin@company.com`, enter `admin`). #### Principal Domain * **Definition**: Default domain for user principals. * **Example**: `company.com` * **Why it matters**: Used to construct full user identifiers when only a username is provided. * **Note**: Typically your organization's Google Workspace domain. #### Enforce Principal Domain * **Definition**: Restricts login to users belonging to the configured Principal Domain. * **Default**: `false` * **Example**: `true` * **Why it matters**: Adds an extra layer of security by limiting access to a specific domain. * **Note**: Useful when combined with the Google Workspace `hd` OIDC Custom Parameter. #### Enable Secure Socket Connection * **Definition**: Enables SSL/TLS for all SSO communication. * **Default**: `false` * **Example**: `true` * **Why it matters**: Ensures encrypted communication between Collate and Google. * **Note**: Recommended in production environments. #### Allowed Domains * **Definition**: List of email domains permitted to authenticate with Collate. * **Example**: `["company.com", "contractor-company.com"]` * **Why it matters**: Provides fine-grained control over which email domains can log in via Google SSO. * **Note**: * Works in conjunction with **Enforce Principal Domain**. * Leave empty if you only use a single domain configured in **Principal Domain**. * Useful when you have multiple Google Workspace domains or want to allow specific external domains. #### Use Roles From Provider * **Definition**: Use roles returned by Google in the token to assign Collate roles. * **Default**: `false` * **Why it matters**: Enables role-based access control driven by your Google Workspace role assignments. * **Note**: Roles must be included in the Google token and must match existing Collate role names. #### Default OAuth Role * **Definition**: Default role assigned to new users when they first sign in via SSO self-signup. * **Example**: `DataConsumer` * **Why it matters**: Controls the starting permission level for new users who join through self-signup. * **Note**: Leave empty to create users without any role. Requires **Enable Self Signup** to be active. The role must already exist in Collate. ### Summary Quick reference of all configuration fields and their example values. | Field | Example / Default | | ------------------------------- | ---------------------------------------------------------------------------------------------------------------------------- | | Provider Name | Google SSO | | Client Type | Confidential | | Enable Self Signup | Enabled | | Authority | [https://accounts.google.com](https://accounts.google.com) | | OIDC Client ID | 123456789012-abc...apps.googleusercontent.com | | OIDC Client Secret | GOCSPX-abc... | | OIDC Request Scopes | openid email profile | | OIDC Discovery URI | [https://accounts.google.com/.well-known/openid-configuration](https://accounts.google.com/.well-known/openid-configuration) | | OIDC Callback URL | `https://openmetadata.company.com/callback` (read-only) | | OIDC Prompt | select\_account | | OIDC Custom Parameters | `{"hd": "company.com"}` | | OIDC Use Nonce | false | | OIDC Disable PKCE | false | | OIDC Max Clock Skew | 0 | | OIDC Token Validity | 3600 | | OIDC Max Age | 3600 | | OIDC Session Expiry | 604800 | | JWT Principal Claims | `["email", "preferred_username", "sub"]` | | JWT Principal Claims Mapping | `["email:email"]` | | JWT Team Claim Mapping | department | | Admin Principals | `["admin", "superuser"]` | | Principal Domain | company.com | | Enforce Principal Domain | false | | Enable Secure Socket Connection | true | | Allowed Domains | `["company.com"]` | | Use Roles From Provider | false | | Default OAuth Role | DataConsumer | ## Troubleshooting If users are automatically logged out and unable to log in again due to a bad authentication configuration, you can reset the security setup using the following command: ``` ./bootstrap/openmetadata-ops.sh remove-security-config --force ``` After executing the command, **restart the server**. The authentication values from your YAML or Helm chart will then be reapplied on startup. The following tiles detail how to apply this configuration: Configure Auth0 SSO to access the UI and APIs. Configure Azure SSO to access the UI and APIs. Configure a custom OIDC SSO to access the UI and APIs. Configure Google SSO to access the UI and APIs. Configure Okta SSO to access the UI and APIs. Configure Amazon Cognito SSO to access the UI and APIs. Configure SAML SSO to access the UI and APIs. Configure LDAP SSO to access the UI and APIs.