SpotApps

SpotApps are ThoughtSpot’s out-of-the-box solution templates built for specific use cases and data sources, such as Snowflake Performance and Consumption, or Jira Issue Management. Starting in ThoughtSpot’s 8.5.0.cl release, SpotApps do not refer to any set of multiple TML files. To learn about migrating custom sets of TML files, refer to Migrate multiple TML files.

SpotApps are built on ThoughtSpot Modeling Language (TML) Blocks, which are pre-built pieces of code that are easy to download and implement directly from the product.

SpotApps use ThoughtSpot’s solution for migrating data models (Worksheets, tables, and views) and content (Liveboards and Answers) between different environments, such as development and production. You can optionally edit these ThoughtSpot objects during the migration process.

SpotApps are not supported on GCP deployments of ThoughtSpot Cloud.

Available SpotApps and Blocks

ThoughtSpot currently supports the following SpotApps, built on Analytics Blocks. Analytics Blocks can include pre-built Worksheet, Answer, and Liveboard Blocks, based on your application data in your cloud data warehouse.

Databricks Storage and Performance

Use this SpotApp to manage Databricks costs and investigate query performance.

DEI Workforce Diversity

Use this SpotApp to get invaluable insight into your workforce diversity data from your HR application.

Facebook Ads

Use this SpotApp to measure ad performance across platforms to grow reach, engagement, & sales.

GBQ Performance and Consumption

Use this SpotApp to manage GBQ costs and consumption.

Google Ad Analysis

Use this SpotApp to get invaluable insight into your Google Ads performance, from high-level usage to identifying popular campaigns.

Google Analytics

Use this SpotApp to analyze Google Analytics data about customer engagement with your website and any ads on the website.

HubSpot Email Marketing

Use this SpotApp to identify the success of your HubSpot email campaigns.

Jira Issue Management

Use this SpotApp to track the number of Jira tickets submitted, and the efficiency of how they are resolved.

Jira Sprint Management

Use this SpotApp to keep your Jira sprints on track with live insights into priorities, backlog, and progress.

LinkedIn Ads

Use this SpotApp to get invaluable insight into your LinkedIn Ads performance, from high-level usage to identifying popular projects.

Okta Application Management

Use this SpotApp to understand any Okta login problems and application adoption within your company.

Procurement Vulnerability Analysis for SAP

Use this SpotApp to quickly identify where disruptions could occur in your global supply chain, reducing risk and building resilience.

Redshift Performance and Consumption

Use this SpotApp to manage Redshift costs and investigate query performance.

Salesforce Pipeline Analysis

Use this SpotApp to track how prospects progress closer to closed deals.

ServiceNow Incident Management and ServiceNow Incident Management (Snowflake Connector for ServiceNow)

Use these SpotApps to track ServiceNow tickets and manage incidents.

Snowflake Performance and Consumption

Use this SpotApp to manage Snowflake costs and investigate query performance.

Snowflake Query Profiling

Use this SpotApp to spot typical mistakes in SQL query expressions to identify potential performance bottlenecks.

SpotApps are built specifically for their application’s out-of-the-box data model. To deploy a SpotApp successfully, you must ensure the data exists in your cloud data warehouse according to the required schema. Customizations can be handled with manual edits during the deployment and mapping process. For more information, refer to Deploying SpotApps.

Prerequisites to deploy SpotApps

To deploy any SpotApp, you must:

  • Review the required tables and columns for the SpotApp. For example, the Jira Sprint Management SpotApp requires the following tables and columns, which you can see in the Jira Sprint Management SpotApp article:

    Table Column Column type Required column

    JIRA_SPRINTS

    ID

    NUMBER

    Yes

    JIRA_SPRINTS

    NAME

    VARCHAR

    Yes

    JIRA_SPRINTS

    STATE

    VARCHAR

    Yes

    JIRA_SPRINTS

    STARTDATE

    TIMESTAMP

    Yes

    JIRA_SPRINTS

    ENDDATE

    TIMESTAMP

    Yes

    JIRA_SPRINTS

    COMPLETEDATE

    TIMESTAMP

    Yes

  • Ensure that your columns match the required column type listed in the schema for your SpotApp.

  • Sync all tables and columns from the application the SpotApp uses (for example, Jira or Hubspot) to your cloud data warehouse. You can sync only the required tables and columns, but ThoughtSpot recommends syncing all tables and columns from the application to your CDW. The columns can be the application’s out-of-the-box columns, or any custom columns that you are using instead of the out-of-the-box columns.

    If you are using an ETL/ELT tool or working with another team in your organization to move data, our recommendation is that you sync all columns from the tables listed in the SpotApp.
  • Ensure that you have completed the SpotApp-specific prerequisites. For example, for the Jira Sprint Management SpotApp, you must also run several SQL commands before deploying the SpotApp. Refer to the individual SpotApp articles to view individual prerequisites. For example, here are the Jira Sprint Management SpotApp prerequisites.

  • Obtain credentials and SYSADMIN privileges to connect to your cloud data warehouse. The cloud data warehouse must contain the data you would like ThoughtSpot to use to create Answers, Liveboards, and Worksheets. Refer to the connection reference for your cloud data warehouse for information about required credentials:

  • The connection name for each new SpotApp must be unique.