Skip to main content
🧪 Preview (Beta)
Suitable for production read workloads.
Most PostgreSQL driver features are supported; some PostgreSQL features may not yet be tested and could behave differently or not work in some tools.
ThoughtSpot ThoughtSpot 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.
ℹ️ Network access requirement
ThoughtSpot does not support mutual TLS (mTLS). In most cases, connections work without additional setup.
If you encounter connectivity issues, your ThoughtSpot IP address may need to be allowlisted by Firebolt. See Allowlisting ThoughtSpot IP Addresses.

​
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.
ThoughtSpot Connection Selection
  1. Create a name for your connection, a description (optional) then enter the connection details for your Firebolt data source:
    FieldValue
    Hostpg.<region_name>.app.firebolt.io
    Port5432
    UserService account ID
    PasswordService account secret
    Database<account_name>@<database_name>@<engine_name>
    ThoughtSpot Connection Configuration

    ​
    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: 
    SELECT region FROM information_schema.accounts WHERE account_name = '<your_account>';

    ​
    Database field details

    Unlike traditional PostgreSQL databases, Firebolt uses a composite string in the Database field to specify:
    • Account name
    • Database name
    • Engine name
    These are joined using @ separators in a single string: 
    <account_name>@<database_name>@<engine_name>
    For example, if your account name is my_account, your database name is sales_db, and your engine name is analytics_engine, you would enter my_account@sales_db@analytics_engine.
  2. Click Next.
  3. Select tables and the columns from each table, and then select Create connection.
  4. A message appears indicating the number of tables and columns that will be added to your connection.
  5. 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. 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.