Connect with ThoughtSpot
On this page
ThoughtSpot is a modern analytics and business intelligence (BI) platform that enables users to run search-driven and AI-powered data analytics.
Refer to SingleStore Overview - ThoughtSpot Documentation for related information.
Create a Connection to SingleStore in ThoughtSpot
To connect to SingleStore from ThoughtSpot:
-
Log in to your ThoughtSpot account.
-
On the Home page, select Create New > Connections.
Alternatively, select Data > Connections > Others. -
Enter a name and description for the connection.
-
From the list of connections, select SingleStore, and then select Continue.
-
On the Create Connection dialog, enter the connection configuration of your SingleStore Helios deployment.
-
Host: Hostname or IP address of your SingleStore deployment.
Refer to SingleStore Helios Endpoints to determine the endpoint (
host:port) of your deployment. -
Port: Port of the SingleStore deployment.
-
User: Username of the SingleStore database user.
-
Password: Password for the SingleStore database user.
-
Database: (Optional) Name of the SingleStore database to connect with.
Enter Database and the database name in the Key and Value fields, respectively. Refer to SingleStore Connection Reference for more supported attributes.
-
(Optional) Configure other settings as required.
-
-
Select Continue.
-
Select the tables and the columns from each (selected) table to add to the connection.
-
Select Create Connection > Create.
The SingleStore connection is added to the Data > Connections page.
After adding the connection, you can start searching your SingleStore database using Search now.
Manage a Connection to SingleStore
Edit a Connection
To edit (or update) an existing SingleStore connection:
-
On the Home page, select Data > Connections.
-
Select the connection to edit, and then select Edit connection.
-
Update the connection details as required, including connection name, configuration, and the selected tables and columns.
-
After making the required changes, select Update.
-
Select Confirm to update the connection.
The selected SingleStore connection is now updated.
Validate Connection Metadata
You can validate a connection to detect any changes in the metadata.
To validate a SingleStore connection:
-
On the Home page, select Data > Connections.
-
Select a connection to validate.
-
Select the ellipsis (three dots), and then select Validate.
If ThoughtSpot detects any changes in the connection's metadata, a message is displayed with the option to download the metadata changes.
Share a Connection
Users with can manage data and admin privileges in ThoughtSpot can share a connection with other ThoughtSpot users or groups with can manage data privilege.
To share a SingleStore connection with another ThoughtSpot user or group:
-
On the Home page, select Data > Connections.
-
Select the connection(s) to share, and then select Share.
-
In the Share connection dialog, enter the ID of the user or group with which to share the connection.
Optionally, search the user or group. -
Select Done.
The selected connection is now accessible to the user or group with the entered ID.
Revoke Access to a Connection
To revoke access for a user or group:
-
On the Home page, select Data > Connections.
-
Select a connection, and then select Share.
-
In the Share connection dialog, select Remove access for a user or group to revoke access.
-
Select Done.
Access is now revoked for the selected user(s) or group(s).
Remap a Connection
To remap the existing tables or columns, update the connection parameters in the source mapping YAML.
To remap a SingleStore connection:
-
On the Home page, select Data > Connections.
-
Select a connection to remap.
-
Select the ellipsis (three dots), and then select Remapping.
-
Select Download to download the source mapping.
-
Update and save the required changes in the mapping file.
-
On the Remapping page, select Browse your files and upload the updated mapping file.
The mapping of the selected connection is now updated.
Delete a Table from a Connection
Before deleting a table, ThoughtSpot checks for dependencies and displays a list of dependent objects.
To delete a table from a SingleStore connection:
-
On the Home page, select Data > Connections.
-
Select a connection.
-
Select the table to delete, and then select Delete.
-
(Optional) If the selected table has dependencies, you must delete or remove all the dependencies.
Otherwise, the delete operation is blocked. The dependencies are listed in the Cannot Delete dialog. To delete the dependencies: -
Select a dependency (linked dependent object) from the Cannot Delete dialog.
-
Modify or delete the object.
-
-
Select Delete to confirm the deletion.
The selected table is now deleted from the connection.
Remarks
-
The selected tables and columns are added as links in ThoughtSpot.
Because ThoughtSpot does not cache the linked data and it queries the linked data, rendering the search results may take a while. -
Tables with dependencies or dependent objects such as Models, Liveboards, or Answers cannot be deleted from a connection.
Passthrough Functions
ThoughtSpot Cloud supports passthrough functions for SingleStore.
Refer to Passthrough functions for SingleStore for information on passthrough functions, including supported passthrough functions, row-level security (RLS) in passthrough functions, and limitations.
Last modified: October 10, 2025