Skip to main content

 

ThoughtSpot

Add a New Data Source

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

Now that you've enabled the Lightweight ETL, you need to add a new data source. Data sources are the source systems from which you want to import data and schedule repeat data loads.

Data sources can consist of:
  • Databases, like Oracle or Teradata.
  • Applications, like Marketo or Salesforce.

To add a data source:

  1. Log in to ThoughtSpot from a browser as an administrator user.
  2. Click on the Data icon, on the left navigation bar.
    File:02_Administration/Administrator_Guide_3.1/040/020/data_icon.png

    The Data icon

  3. Click the Data Sources tab at the top, and select + New data source on the upper right hand side of the panel.
    File:02_Administration/Administrator_Guide_3.1/040/020/data_sources_tab.png

    New data source

  4. Select which type of connection you wish to use from the available list.
  5. Select a connection type and click Next.
    File:02_Administration/Administrator_Guide_3.1/040/020/lightweight_etl_select_connection.png

    Select a connection type

  6. To select a connection, choose one of these options:
    • Select a pre-defined connection type, by choosing it from the Select Connection list:
      File:02_Administration/Administrator_Guide_3.1/040/020/lightweight_etl_select_existing_connection.png

      Select a connection type

    • Click + to create the connection and provide the credentials to your data source. Then click Test & Create:
      File:02_Administration/Administrator_Guide_3.1/040/020/lightweight_etl_create_new_connection.png

      Create a connection

  7. Choose the tables you wish to load from the list of Available Tables.
    Expand a table to see its columns by clicking the small arrow next to its name. Select the specific columns to import.
    File:02_Administration/Administrator_Guide_3.1/040/020/lightweight_etl_select_columns.png

    Selecting columns

  8. When all the columns are selected, click > to move them to the Selected Tables box. Click Next.
  9. You can optionally apply a filter to only import specific rows by clicking New... under Data Filters.
    Select a table, a column, operator, and value. Click OK. You can create as many filters as you need by clicking + and repeating this step.
    File:02_Administration/Administrator_Guide_3.1/040/020/lightweight_etl_filter.png

    Apply a Data Filter

  10. You can optionally apply data transformations and write the result to a new column by clicking New... under Expressions.
    Give the new column a name, select the table the data will come from, and create an expression. Click Add Column. You can create as many expressions as you need by clicking + and repeating this step.
    File:02_Administration/Administrator_Guide_3.1/040/020/lightweight_etl_expression.png

    Apply an Expression

  11. Click Next. Provide a Source Name for the data source.
  12. Check the list of columns to be imported, to make sure it is correct. If you are loading into new or empty tables, or if you want to delete any data that already exists in the tables, click the checkbox to select Truncate data in the existing tables.
  13. If you want to specify repeat data loads, create a loading schedule.
    File:02_Administration/Administrator_Guide_3.1/040/020/lightweight_etl_schedule.png

    Schedule ETL

  14. Click Import.
  • Was this article helpful?