Skip to main content
ClickHouse Cloud supports single-sign on (SSO) via security assertion markup language (SAML). This enables you to sign in securely to your ClickHouse Cloud organization by authenticating with your identity provider (IdP). We support service provider-initiated SSO, multiple organizations using separate connections, and just-in-time provisioning. We also support SCIM provisioning in private preview, with support for Okta. We don’t yet support attribute mapping. Customers enabling SAML integrations can also designate the default role that will be assigned to new users and adjust session timeout settings.

Before you begin

You will need Admin permissions in your IdP, the ability to add a TXT record to the DNS settings for your domain, the Admin role in your ClickHouse Cloud organization. We recommend setting up a direct link to your organization in addition to your SAML connection to simplify the login process. Each IdP handles this differently. Read on for how to do this for your IdP.

How it works

Once SAML SSO is configured, users sign in through a service-provider-initiated flow:
  1. The user goes to https://console.clickhouse.cloud and enters their email address (or uses your organization’s direct link).
  2. ClickHouse Cloud redirects them to your identity provider to authenticate.
  3. On success, the identity provider redirects them back to ClickHouse Cloud.
  4. ClickHouse Cloud signs them in, provisioning the account just-in-time on first login and assigning your configured default role.
The rest of this guide covers the one-time configuration.

How to configure your IdP

1

Access Organization settings

Click on your organization name in the lower left corner and select Organization details.
2

Enable SAML single sign-on

Click the toggle next to Enable SAML single sign-on. Leave this screen open as you will refer back to it several times during the setup process.
3

Create an application in your identity provider

Create an application within your identity provider and copy the values on the Enable SAML single sign-on screen to your identity provider configuration. For more information on this step, refer to your specific identity provider below.
ClickHouse doesn’t support identity provider initiated sign-in. To make it easy for your users to access ClickHouse Cloud, set up a bookmark for your users using this sign-in URL format: https://console.clickhouse.cloud/?connection={orgId} where the {orgID} is your organization ID on the Organization details page.
4

Add the metadata URL to your SAML configuration

Obtain the Metadata URL from your SAML provider. Return to ClickHouse Cloud, click Next: Provide metadata URL and paste the URL in the text box.
5

Get domain verification code

Click Next: Verify your domains. Enter your domain in the text box and click Check domain. The system will generate a random verification code for you to add to a TXT record with your DNS provider.
6

Verify your domain

Create a TXT record with your DNS provider. Copy the TXT record name to the TXT record Name field with your DNS provider. Copy the Value to the Content field with your DNS provider. Click Verify and Finish to complete the process.
It may take several minutes for the DNS record to update and be verified. You may leave the setup page and return later to complete the process without restarting. The verification value is valid for 48 hours from when it is first generated.
7

Update default role and session timeout

Once the SAML setup is complete, you can set the default role(s) all users will be assigned when they log in and also adjust session timeout settings. For a list of available system roles that may be assigned, please review Console roles and permissions.
8

Configure your admin user

Users configured with a different authentication method will be retained until an admin in your organization removes them.
To assign your first admin user via SAML:
  1. Log out of ClickHouse Cloud.
  2. In your identity provider, assign the admin user to the ClickHouse applications.
  3. Ask the user to log in via https://console.clickhouse.cloud/?connection={orgId} (shortcut URL). This may be via a bookmark you created in the prior steps. The user won’t appear in ClickHouse Cloud until their first login.
  4. If the default SAML role is anything other than Admin, the user may need to log out and log back in with their original authentication method to update the new SAML user’s role.
    • For email + password accounts, please use https://console.clickhouse.cloud/?with=email.
    • For social logins, please click the appropriate button (Continue with Google or Continue with Microsoft)
email in ?with=email above is the literal parameter value, not a placeholder
  1. Log out one more time and log back in via the shortcut URL to complete the last step below.
To reduce steps, you may set your SAML default role to Admin initially. When the admin is assigned in your identity provider and logs in for the first time, they can change the default role to a different value.
9

Remove other authentication methods

Remove any users that are using a non-SAML method to complete the integration and restrict access to only users originating from your identity provider connection.

Configure your identity provider

You will configure two App Integrations in Okta for each ClickHouse organization: one SAML app and one bookmark to house your direct link.

Create a group to manage access

  1. Log in to your Okta instance as an Administrator.
  2. Select Groups on the left.
  3. Click Add group.
  4. Enter a name and description for the group. This group will be used to keep users consistent between the SAML app and its related bookmark app.
  5. Click Save.
  6. Click the name of the group that you created.
  7. Click Assign people to assign users you would like to have access to this ClickHouse organization.

Create a bookmark app to enable users to seamlessly log in

  1. Select Applications on the left, then select the Applications subheading.
  2. Click Browse App Catalog.
  3. Search for and select Bookmark App.
  4. Click Add integration.
  5. Select a label for the app.
  6. Enter the URL as https://console.clickhouse.cloud/?connection={organizationid}
  7. Go to the Assignments tab and add the group you created above.

Create a SAML app to enable the connection

  1. Select Applications on the left, then select the Applications subheading.
  2. Click Create App Integration.
  3. Select SAML 2.0 and click Next.
  4. Enter a name for your application and check the box next to Don’t display application icon to users then click Next.
  5. Use the following values to populate the SAML settings screen.
  6. Enter the following Attribute Statement.
  7. Click Next.
  8. Enter the requested information on the Feedback screen and click Finish.
  9. Go to the Assignments tab and add the group you created above.
  10. On the Sign On tab for your new app, click the Copy metadata URL button.
  11. Return to Add the metadata URL to your SAML configuration to continue the process.

Troubleshooting

Cause: identity-provider-initiated login, which isn’t supported.Fix: use the direct link https://console.clickhouse.cloud/?connection={organizationid}. Follow the instructions for your identity provider above to make this the default login method for your users.
Cause: the identity provider doesn’t have the email attribute mapping.Fix: follow the instructions for your identity provider above to configure the user email attribute, then log in again.
Cause: the user hasn’t been assigned to the ClickHouse application in the identity provider.Fix: assign the user to the application in the identity provider and log in again.
Cause: you’re still logged in to the first organization.Fix: log out, then log in to the other organization.
Cause: your email domain doesn’t match the domain configured.Fix: reach out to support for assistance resolving this error.

Frequently asked questions

No — only service-provider-initiated flows. Users navigate to https://console.clickhouse.cloud and enter their email to be redirected to your identity provider. Set up a bookmark or direct link (https://console.clickhouse.cloud/?connection={organizationid}) so users don’t have to remember the URL.
ClickHouse Cloud supports multi-organization SSO with a separate connection per organization. Use the direct link (https://console.clickhouse.cloud/?connection={organizationid}) to log in to each one, and log out of one organization before logging into another. If you don’t want users on your domain routed to an organization automatically when they enter their email at https://console.clickhouse.cloud, open a support ticket to remove that behavior.
ClickHouse Cloud doesn’t automatically link SSO and non-SSO accounts, so a user who has signed in both ways may appear more than once in your user list even with the same email address.

Next steps

Last modified on July 20, 2026