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

> Connecting ThoughtSpot and Firebolt.

# ThoughtSpot

<Callout type="info">
  🧪 **Preview (Beta)** <br />
  Suitable for production read workloads.<br />
  Most PostgreSQL driver features are supported; some PostgreSQL features may not yet be tested and could behave differently or not work in some tools.
</Callout>

<img src="https://mintcdn.com/firebolt/pEyspi0FiW9QQRN6/assets/images/thoughtspot.png?fit=max&auto=format&n=pEyspi0FiW9QQRN6&q=85&s=f8f3a6478788159b2234ac1519e00260" alt="ThoughtSpot" width="371" height="136" data-path="assets/images/thoughtspot.png" />

[ThoughtSpot](https://www.thoughtspot.com/) is a modern analytics platform that enables users to search and analyze data using natural language queries. You can use ThoughtSpot's interface to explore, visualize, and create interactive dashboards from your data.

This guide shows you how to create a connection between ThoughtSpot and your Firebolt database.

<Callout type="info">
  ℹ️ **Network access requirement** <br />
  ThoughtSpot does not support mutual TLS (mTLS). In most cases, connections work without additional setup. <br />
  If you encounter connectivity issues, your ThoughtSpot IP address may need to be allowlisted by Firebolt. See [Allowlisting ThoughtSpot IP Addresses](#allowlisting-thoughtspot-ip-addresses).
</Callout>

## Step-by-Step Guide

1. Select **Data workspace** tab.

2. Select the **Connections** section in the left navigation bar, and then press the **Create connection** button.

3. Find and select the **PostgreSQL** tile as the connection type and click **Next**.

<img src="https://mintcdn.com/firebolt/pEyspi0FiW9QQRN6/assets/images/thoughtspot-selection.png?fit=max&auto=format&n=pEyspi0FiW9QQRN6&q=85&s=c2806ad627b15bbbd5e1fbdadd5e4451" alt="ThoughtSpot Connection Selection" width="772" height="557" data-path="assets/images/thoughtspot-selection.png" />

4. Create a name for your connection, a description (optional) then enter the connection details for your Firebolt data source:

   | Field        | Value                                               |
   | ------------ | --------------------------------------------------- |
   | **Host**     | `pg.<region_name>.app.firebolt.io`                  |
   | **Port**     | `5432`                                              |
   | **User**     | `<account name>:<engine name>:<Service account ID>` |
   | **Password** | Service account secret                              |
   | **Database** | Database name                                       |

   #### Host details

   When using Firebolt's PostgreSQL-compatible interface, the host URL is based only on the region.

   **Host URL Format:** `pg.<region_name>.app.firebolt.io`

   `<region_name>` — The region your account is hosted in (e.g., us-east-1)

   **How to Find Your Region:** Use this SQL query in Firebolt to get the region for your account:

   ```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
   SELECT region FROM information_schema.accounts WHERE account_name = '<your_account>';
   ```

   #### User field details

   Unlike traditional PostgreSQL databases, Firebolt uses a composite string in the User field to specify:

   * Account name
   * Engine name
   * Service account ID

   These are joined using `:` separators in a single string:

   ```
   <account name>:<engine name>:<service_account_id>
   ```

   For example, if your account name is `my_account`, your engine name is `analytics_engine`, and your service account id is `fbcid_xxx` you would enter `my_account:analytics_engine:fbcid_xxx`.

5. Click **Next**.

6. Select tables and the columns from each table, and then select **Create connection**.

7. A message appears indicating the number of tables and columns that will be added to your connection.

8. Select **Create connection**. Once the connection is added, you can query the Firebolt tables selected via Spotter straight away.

## Allowlisting ThoughtSpot IP Addresses

ThoughtSpot does not support mutual TLS (mTLS).

If you experience connectivity issues when connecting ThoughtSpot to Firebolt, your ThoughtSpot IP address may need to be allowlisted by Firebolt.

### Get your ThoughtSpot IP address

1. During the connection setup, locate the **Connection tips** panel on the right side of the screen.
2. Copy the IP address displayed.

### Request allowlisting

Contact Firebolt Support and request to allowlist the ThoughtSpot IP address for your account.

See more about how to contact [Firebolt Support and the severity guidelines](/support/severity-guidelines).

Include the following information in your request:

* Your name and email address
* Your organization name
* Name of the tool you want to connect (ThoughtSpot in this case)
* The ThoughtSpot IP address to allowlist

After allowlisting is completed, return to ThoughtSpot and retry the connection.

## Additional Resources

For more information about ThoughtSpot configuration and troubleshooting, refer to the ThoughtSpot [documentation](https://docs.thoughtspot.com/cloud).