# Connect with ThoughtSpot ThoughtSpot is a modern analytics and business intelligence (BI) platform that enables users to run search-driven and AI-powered data analytics. You can integrate your SingleStore databases with ThoughtSpot and generate Answers and Liveboards using live queries. Refer to [SingleStore Overview - ThoughtSpot Documentation](https://docs.thoughtspot.com/cloud/latest/connections-singlestore) for related information. ## Create a Connection to SingleStore in ThoughtSpot To connect to SingleStore from ThoughtSpot: 1. Log in to your ThoughtSpot account. 2. On the Home page, select **Create New > Connections**. Alternatively, select **Data > Connections > Others**. 3. Enter a name and description for the connection. 4. From the list of connections, select **SingleStore**, and then select **Continue**. 5. On the **Create Connection** dialog, enter the connection configuration of your SingleStore deployment. 1. **Host**: Hostname or IP address of your SingleStore deployment. 2. **Port**: Port of the SingleStore deployment. 3. **User**: Username of the SingleStore database user. 4. **Password**: Password for the SingleStore database user. 5. **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](https://docs.thoughtspot.com/cloud/latest/connections-singlestore-reference) for more supported attributes. 6. (Optional) Configure other settings as required. 6. Select **Continue**. 7. Select the tables and the columns from each (selected) table to add to the connection. 8. Select **Create Connection > Create**. The SingleStore connection is added to the **Data > Connections** page. Select the name of the connection to view the tables and columns added to the connection. 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: 1. On the Home page, select **Data > Connections**. 2. Select the connection to edit, and then select **Edit connection**. 3. Update the connection details as required, including connection name, configuration, and the selected tables and columns. 4. After making the required changes, select **Update**. 5. 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. Upon validation, ThoughtSpot generates a JSON file with metadata changes. Use ThoughtSpot Modeling Language (TML) to apply the update to the connection. To validate a SingleStore connection: 1. On the Home page, select **Data > Connections**. 2. Select a connection to validate. 3. 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. Select **Download metadata change log** to download the JSON with 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. A user or group with access to a connection can add, remove, and modify tables in the connection. To share a SingleStore connection with another ThoughtSpot user or group: 1. On the Home page, select **Data > Connections**. 2. Select the connection(s) to share, and then select **Share**. 3. 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. 4. 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: 1. On the Home page, select **Data > Connections**. 2. Select a connection, and then select **Share**. 3. In the **Share connection** dialog, select **Remove access** for a user or group to revoke access. 4. 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. Check the dependencies before and after remapping. To remap a SingleStore connection: 1. On the Home page, select **Data > Connections**. 2. Select a connection to remap. 3. Select the ellipsis (three dots), and then select **Remapping**. 4. Select **Download** to download the source mapping. 5. Update and save the required changes in the mapping file. 6. 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. You cannot delete a table with dependent objects; update or delete the dependent objects before deleting a table from a connection. To delete a table from a SingleStore connection: 1. On the Home page, select **Data > Connections**. 2. Select a connection. 3. Select the table to delete, and then select **Delete**. 4. (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: 1. Select a dependency (linked dependent object) from the **Cannot Delete** dialog. 2. Modify or delete the object. 5. 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. Passthrough functions enable you to send custom SQL queries directly to SingleStore. ThoughtSpot does not interpret the expressions sent via passthrough functions. Refer to [Passthrough functions for SingleStore](https://docs.thoughtspot.com/cloud/latest/connections-singlestore-passthrough) for information on passthrough functions, including supported passthrough functions, row-level security (RLS) in passthrough functions, and limitations. *** Modified at: October 10, 2025 Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-thoughtspot/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-thoughtspot/) (An index of the documentation is available at /llms.txt)