Skip to main content

 

ThoughtSpot

About making changes to Data Connect setup

  1. Last updated
    10:40, 27 Apr 2017
  2. Save as PDF

Overview

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

Feature

After setting up ThoughtSpot Data Connect, you may want to make changes to the scheduling, data sources, or even the schema you are importing into in ThoughtSpot. These best practices describe how to make such changes.

Changes to data sources

If your company migrates from one source database or application to another you may find that you need to redo the data import using the new system. You can do this without losing any data that has already been loaded into ThoughtSpot, but you need to be careful not to accidentally delete an existing table that was created by the old data source. Create the new data source, but choose to retain the table when you delete the old data source. You should also stop any scheduled jobs associated with the old data source before deletion.

Changes to scheduled data imports

It's easy to change scheduled data imports to run at a different time or frequency through the Data Connect web interface. You may also want to pause a data import because the source system will be offline for maintenance. You can then resume it, when the maintenance has been completed.

Changes to the Schema in ThoughtSpot

It is very common to need to change what you're importing into ThoughtSpot for various reasons. For example the source database may have changed, because you've implemented a new application. Or you might simply change your mind about the best way to model the data that was brought in through Data Connect.
  • Edit a connection
    You can edit a connection used in a data source.
  • Delete a connection
    You can delete a connection, but only once you've resolved each of its dependencies.
  • Delete a data source
    If you want to delete a data source, make sure and read this section so you don't inadvertently delete data in ThoughtSpot.
  • Stop a scheduled job from running
    You may want to stop a scheduled job from running for a time, or even permanently. Use this procedure to pause or stop a job.
  • Change sharding for a data source
    Use this procedure to change the sharding on a data source after it has been set up and the load has run. You can still change the number of shards or make it a replicated table instead.
  • Change a data type for a data source
    When a data type used in a data source has changed, or you decide that the data should come into ThoughtSpot with a different data type, you can change the data type, even if you've already loaded data into the target table.
  • Add a column to an existing data source
    You can add a column to an existing data source using this procedure. This will work even if the data load has already been run in the past.
  • Remove a column from an existing data source
    You can remove a column from a data source, even if its data load has been run in the past, by using this procedure.
  • Add/remove columns in a loaded table
    You can modify tables that have been selected for load in Data Connect by adding or removing columns.
  1. Back to top
  • Was this article helpful?

Recommended articles

  1. There are no recommended articles.
  1. Article type
    Topic
    Release
    Version 4.2
  2. Tags
    1. 4.2
    2. source:chm
    3. stage:review