System Models, tables, and views

Most of the monitoring information in ThoughtSpot’s system Liveboards comes from system Models, 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 Models and views.

List the system Models, tables, and views

To list the system Models, 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 Models, 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.

Credit Usage Model

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

Discover Monitoring Data

This Model 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 Model 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 Models, 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 Model 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 Model 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. ThoughtSpot now distinguishes between regular query consumption and Spotter queries. Used for the Billable Query Stats Liveboard. Currently, Spotter queries will not show up in a separate visualization on the Billable Query Stats Liveboard.