ThoughtSpot Connector for Data Prep¶
User Persona: Data Prep User, Data Prep Admin, Data Source Admin, or IT/DevOps
This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.
Configure Data Prep¶
This connector allows you to export your Data Prep AnswerSets to ThoughtSpot. The following fields are used to define the connection parameters.
- Name: Name of the data source as it will appear to users in the UI.
- Description: Description of the data source as it will appear to users in the UI.
You can connect Data Prep to multiple ThoughtSpot instances. Using a descriptive name can be a big help to users in identifying the appropriate data source.
ThoughtSpot Server Configuration¶
- Hostname: ThoughtSpot server hostname or IP address.
- Port: ThoughtSpot server port. The standard port is 22.
ThoughtSpot User Configuration¶
User: The user on the ThoughtSpot server. (This is the SSH username, not the username for logging in on ThoughtSpot web app. See the Thoughtspot documentation for more information on login credentials.)
Password: The password for the user on the ThoughtSpot server.
Behavior for Exporting into Existing Table: Select the action that Data Prep should take upon export if a table with the same name already exists in the selected database and schema.
Append New Data to Existing Table: Data Prep will add the new rows of data to the existing table.
Drop Existing Table and Create New Table: Data Prep will drop all existing rows and columns, and create a new table with the new data.
Empty Target Table and Add New Data: Data Prep will keep the existing table but remove the row values and fill in the new data.
If there is no existing table that matches the name specified in export, then all of the options are equivalent: all of them will create a new table and load all of the rows from the dataset.
Data Export Information¶
View list of databases and schemas within ThoughtSpot.
Via SQL Query¶
During the set up of the Connector Config and Data Source Config, you have the option to select the behavior for the export. These settings are configured once and used over and over again. With this, if you want one export to truncate the table and one to append, you should create one Connector Config where you leave this setting blank, then create two Data Source Configs, one where you specify the append behavior, the other where you specify truncate. Be sure to give the Data Sources clear names.