Skip to main content



Add a New Data Source


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


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.

    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.

    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.

    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:

      Select a connection type

    • Click + to create the connection and provide the credentials to your data source. Then click Test & Create:

      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.

    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.

    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.

    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.

    Schedule ETL

  14. Click Import.
  • Was this article helpful?