System Worksheets, tables, and views

Most of the monitoring information in ThoughtSpot’s system Liveboards comes from system Worksheets, tables, and views that administrators can view, but not modify. The underlying tables are protected system tables that you cannot access directly. However, administrators can create new, custom monitoring reports from the Worksheets and views.

List the system Worksheets, tables, and views

To list the system Worksheets, tables, and views:

  1. Go to the Data tab.

  2. Choose All and All types.

  3. Enter System User in the search field.

Description of system Worksheets, tables, and views

Credits Purchased

Contains data on the number of credits for consumption-based pricing your cluster has, and their expiration date. Used for the Credit Usage Liveboard.

Sample Retail - Apparel

Contains sample retail data for Search Assist.

Credit Usage Worksheet

Tracks the credits for consumption-based pricing your cluster has consumed. Used for the Credit Usage Liveboard.

Discover Monitoring Data

This Worksheet contains data on how users are searching for existing Answers and Liveboards. It contains information on what users are searching for, where users are successful and where they are not. This Worksheet contains data from the MetricsMonitoring table, and is used for the How Users are Searching Answers Liveboard.

Product Usage

Contains usage data for the product. Specifies what existing Worksheets, tables, and views users search on and create objects from, and what those objects are. Specifies what actions users complete in the product. You can also use this Worksheet to view the underlying data sources for any objects, and any object’s dependents.

MetricsMonitoring

This table contains data on how users are searching for existing Answers and Liveboards. It contains information on what users are searching for, where users are successful and where they are not, based on click count and position. This table is a source for the Discover Monitoring Data Worksheet and the How Users are Searching Answers Liveboard.

TS: BI Server

Contains data related to the systems associated with underlying the ThoughtSpot BI server. This includes database latency, browser clients, size of responses, and more.

TS: External Table Current Row Count

Contains data related to the row count for external tables, or tables loaded through Connections.

TS: Rows of un-cached tables for each connection

Contains data related to the sum of rows count for each un-cached table in a connection.

TS: External Table Info

Contains data related to external tables, or tables loaded through Connections.

TS: Daily Row Count External Table

Contains Connections data, stored on a daily basis: the number of rows in your external database, and whether each external table is cached or not.

TS: Query Stats

Contains data related to billable query consumption for customers on the query-based consumption pricing model. Used for the Billable Query Stats Liveboard.