Overview¶
Alation Cloud Service Applies to Alation Cloud Service instances of Alation
Customer Managed Applies to customer-managed instances of Alation
To get the enhanced connector for ThoughtSpot, contact the Forward Deployed Engineering team at Alation.
This connector extracts ThoughtSpot objects such as Worksheets, Tables, Answers, Datasources, Liveboards, and Answers’ measures and dimensions. Users will be able to search and find the ThoughtSpot objects and understand the business transformation on their data from the Alation user interface.
Team¶
The following administrators are required to install this connector:
BI Admin:
Provides the ThoughtSpot URI
Provides the ThoughtSpot account with admin privilege
Alation Server Admin:
Installs the connector
Creates a BI source
Configures the BI source
Scope¶
The table below describes which metadata objects are extracted by this connector and which operations are supported.
Feature |
Scope |
Availability |
|---|---|---|
Metadata extraction |
Extract the metadata in Object Mapping |
Yes |
Report Lineage |
Intra-system lineage - Example: Worksheet to Answers to Liveboards |
Yes |
Cross System Lineage |
End-to-end lineage at the system level from the RDBMS data source to the ThoughtSpot data source. Example: Snowflake Table to ThoughtSpot worksheet |
Yes |
Colum Level Lineage |
Column level lineage refers to the ability to trace columns across data sources in the “Lineage” tab for a catalogued object |
No |
ThoughtSpot Object Usage Statistics |
Popularity on Answer and Liveboard |
Yes |
Permission Mirroring |
Replicate ThoughtSpot permissions into Alation |
Yes |
Report/Dashboard Previews |
Image Previews or Report thumbnails stored in Thoughtspot |
No |
Link to Source System |
Navigation(navigation link to the object in ThoughtSpot |
Yes |
Selective Extraction |
Ability to apply filters on Organization |
Yes |
Full Extraction |
Ability to run full extraction on the ThoughtSpot instance |
Yes |
Object Mapping¶
- The diagram and table below describe which metadata objects are extracted by this connector and how they are mapped to objects in Alation.
Connector API Methods¶
The following table lists the ThoughtSpot APIs used by this connector to extract metadata from ThoughtSpot:
Type |
Category |
Endpoint |
Description |
|
|---|---|---|---|---|
Organization |
BI Folders |
/api/rest/2.0/orgs/search |
The multi-tenancy feature logically partitions a ThoughtSpot cloud instance into multiple tenant-specific environments called Orgs |
|
Worksheet |
BI Datasource |
/api/rest/2.0/metadata/search |
Logical views of data to model complex datasets |
|
Table |
BI Datasource |
/api/rest/2.0/metadata/search |
Tables imported from external source system |
|
View/SQL view |
BI Datasource |
/api/rest/2.0/metadata/search |
Virtual tables created by saving a ThoughtSpot data search |
|
Liveboard |
Dashboard |
/api/rest/2.0/metadata/search |
Dashboards, collections of Answers |
|
Answers |
Report |
/api/rest/2.0/metadata/search |
Saved results of any search |
|
Answers Measure |
Measure and Measure expression |
/api/rest/2.0/metadata/answer/data |
Numeric values can be found on the y-axis of the Answer |
|
Answers Attribute |
Dimension |
/api/rest/2.0/metadata/answer/data |
Text or date values can be found on the x-axis of the Answer |
|