Skip to main content

About the ThoughtSpot collector

Use this collector to directly harvest metadata ThoughtSpot Answers and Liveboards into data.world

Important

The ThoughtSpot collector can be run in the Cloud or on-premise using Docker or Jar files.

Note

The latest version of the Collector is 2.189. To view the release notes for this version and all previous versions, please go here.

What is cataloged

The collector catalogs the following information.

Table 1.

Object

Information cataloged

Answer

Title, Description, Tags, SQL query, Created by, Creation date, Last modified by, Last modified date, External URL

Liveboard

Title, Description, Tags, SQL query, Created by, Creation date, Last modified by, Last modified date, External URL

Logical Column

Title, Description, Tags, Column Index, Column Type Name, Column Precision, Is Primary Key, Creation date, Last modified by, Last modified date, Created by

Logical table

Title, Description, Tags, Created by, Creation date, Last modified by, Last modified date

Workbook

Title, Description, Tags, Created by, Creation date, Last modified by, Last modified date

Formula

Title, Formula text, Created by, Last modified by, Last modified date, Created date

Tag

Title, Count of resources with tag, Description, Creation date, Last modified by, Last modified date



Relationships between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.

Table 2.

Resource page

Relationship

Answer

  • Relationship to Tags that the Answer is associated with

Liveboard

  • Relationship to Tags that the Liveboard is associated with

Logical Column

  • Relationship to Logical Tables that the Logical Column is part of 

  • Relationship to Tags that the Logical Column is associated with

  • Relationship to Formulae that the Logical Column is associated with

Logical Table

  • Relationship to Logical Columns contained in Logical Table

  • Relationship to Tags that the Logical Table is associated with

Workbook

  • Relationship to Logical Columns contained in Workbook

  • Relationship to Tags that the Workbook is associated with

Formula

  • Relationship to the Logical Column that contains the Formula

Tag

  • Relationship to Answer, Liveboard, Logical Column, Logical Table, or Workbook resources that the Tag is associated with



Lineage for ThoughtSpot

The following lineage information is collected by the Thoughtspot collector.

Table 3.

Object

Logical column

  • Associated source column in an upstream source

  • Associated downstream Answers and Liveboards



Authentication supported

  • The collector authenticates to ThoughtSpot using username and password. The collector will have access to all the resources that the ThoughtSpot account has access to.