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.
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.
Deploying SpotApps
After you complete the prerequisites, you are ready to deploy SpotApps and begin leveraging their pre-built content.
Refer to the following articles, depending on the SpotApp you would like to deploy:
