(warning) The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.

ThoughtSpot Connector Documentation

User Persona:  Paxata User - Paxata Admin - Data Source Admin - IT/DevOps

*Note: This document covers all configuration fields available during Connector setup. Some fields may have already been filled out by your Admin at an earlier step of configuration and may not be visible to you. For more information on Paxata’s Connector Framework, please see here.

Also: Your Admin may have named this Connector something else in the list of Data Sources.

Configuring Paxata

This connector allows you to export your Paxata AnswerSets to ThoughtSpot. The following fields are used to define the connection parameters.

General

  • 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.

Something to consider: You may connect Paxata to multiple ThoughtSpot instances and having 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. (SSH username – not username for logging in on ThoughtSpot web app. See here for more information on login credentials.)

  • Password: The password for the user on the ThoughtSpot server.

Export Configuration

  • Behavior for Exporting into Existing Table: Select the action that Paxata 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: Paxata will add the new rows of data to the existing table.

    • Drop Existing Table and Create New Table: Paxata will drop all existing rows and columns, and create a new table with the new data.

    • Empty Target Table and Add New Data: Paxata will keep the existing table but remove the row values and fill in the new data.

  • Note: 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

Via Browsing

View list of databases and schemas within ThoughtSpot.

Via SQL Query

Not Supported.

Best Practices

  • 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.