> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

> ThoughtSpot is an AI-powered analytics platform that lets you search, explore, and visualize your data in real time.

# ThoughtSpot

export const PartnerBadge = () => {
  return <div className="PartnerBadge">
            <div className="PartnerBadgeIcon">
                <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                    <polyline points="12.5 9.5 10 12 6 11 2.5 8.5" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <polyline points="4.54 4.41 8 3.5 11.46 4.41" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <path d="M2.15,3.78 L0.55,6.95 A0.5,0.5 0,0,0 0.77,7.62 L2.5,8.5 L4.54,4.41 L2.82,3.55 A0.5,0.5 0,0,0 2.15,3.78 Z" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <path d="M13.5,8.5 L15.23,7.62 A0.5,0.5 0,0,0 15.45,6.95 L13.85,3.78 A0.5,0.5 0,0,0 13.18,3.55 L11.46,4.41 Z" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <path d="M11.5,4.5 L9,4.5 L6.15,7.27 A0.5,0.5 0,0,0 6.24,8.05 C7.33,8.74 8.81,8.72 10,7.5 L12.5,9.5 L13.5,8.5" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <polyline points="7.75 13.5 5.15 12.85 3.5 11.67" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                </svg>
            </div>
            Partner Integration
        </div>;
};

<PartnerBadge />

ThoughtSpot can connect to ClickHouse Cloud or on-premise deployment via its native ClickHouse connector.

<Steps>
  <Step title="Gather your connection details" id="1-gather-your-connection-details">
    To connect to ClickHouse with HTTP(S) you need this information:

    | Parameter(s) | Description |
    | - | - |
    | `HOST` and `PORT` | Typically, the port is 8443 when using TLS or 8123 when not using TLS. |
    | `DATABASE NAME` | Out of the box, there is a database named `default`, use the name of the database that you want to connect to. |
    | `USERNAME` and `PASSWORD` | Out of the box, the username is `default`. Use the username appropriate for your use case. |

    The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console.
    Select a service and click **Connect**:

    <div className="ch-image-md">
      <Frame>
        <img src="https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/_snippets/cloud-connect-button.webp" alt="ClickHouse Cloud service connect button" />
      </Frame>
    </div>

    Choose **HTTPS**. Connection details are displayed in an example `curl` command.

    <div className="ch-image-md">
      <Frame>
        <img src="https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/_snippets/connection-details-https.webp" alt="ClickHouse Cloud HTTPS connection details" />
      </Frame>
    </div>

    If you're using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.
  </Step>

  <Step title="Create a ClickHouse connection in ThoughtSpot" id="2-create-a-clickhouse-connection-in-thoughtspot">
    1. Navigate to **Data workspace** > **Connections**.

    2. Click **+ Create connection**, select the **ClickHouse** tile, then click **Next**.

    3. Enter a name for your connection, an optional description, and the ClickHouse connection details you gathered in the previous step, then click **Next**. For details on each attribute, see the [ClickHouse connection reference](https://docs.thoughtspot.com/cloud/latest/connections-clickhouse-reference) in the ThoughtSpot documentation.

    4. (Optional) To configure a query-level timeout, open the **Advanced Config** menu. For **Key**, enter `queryTimeoutSeconds`. For **Value**, enter the timeout in seconds. A maximum of 10 minutes is recommended.

    5. (Optional) To provide additional key-value pairs, open the **Advanced Config** menu and enter a **Key** and **Value**. Click the plus sign (**+**) to add more pairs.

           <Note>
             Any key-value pairs that you enter must be defined in your ClickHouse data source. Key-value pairs are case-sensitive.
           </Note>

    6. Select the tables and columns you want to use, then click **Create connection**. A message confirms the number of tables and columns added.

    The connection now appears on the **Data workspace** > **Connections** page. You can search your ClickHouse data and run live queries on the linked tables in ThoughtSpot.
  </Step>
</Steps>