Jira Sprint Management SpotApp

SpotApps are ThoughtSpot’s out-of-the-box solution templates built for specific use cases and data sources. They 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.

The Jira Sprint Management SpotApp mimics the Jira data model. When you deploy it, ThoughtSpot creates several Worksheets, Answers, and Liveboards, based on your Jira data in your cloud data warehouse.

This is a sample Liveboard, created after you deploy the Jira Sprint Management SpotApp:

Jira Sprint SpotApp Liveboard

Use the Jira Sprint Management SpotApp to manage your Jira sprints. You can improve prioritization and visibility of issues, and increase team productivity.

Prerequisites

Before you can deploy the Jira Sprint Management SpotApp, you must complete the following prerequisites:

Run SQL commands

The following SQL commands help standardize data types and column names. Replace the database name, schema name, and sprint table name with your specific information.

The following SQL example is for the Snowflake cloud data warehouse. You may need to modify the code for the SQL requirements of your specific cloud data warehouse.

SQL commands:

Open the dropdown menu to view the SQL commands.
create or replace view "<DATABASE NAME>"."<SCHEMA NAME>"."JIRA_SPRINTS" as select
ID as Id,
NAME as Name,
GOAL as Goal,
BOARD_ID as OriginBoardId,
START_DATE as StartDate,
END_DATE as EndDate,
COMPLETE_DATE as CompleteDate from "<DATABASE NAME>"."<SCHEMA NAME>"."<SPRINT TABLE NAME>";

If you moved your data using Fivetran, you must also run the following command. Replace DATABASE NAME, SCHEMA NAME, and SPRINT TABLE NAME with your specific information.

create or replace view "<DATABASE NAME>"."<SCHEMA NAME>"."JIRA_SPRINTS" as
select
ID as Id,
NAME as Name,
case
when "START_DATE" is not NULL and "COMPLETE_DATE" is NULL then 'active'
when "COMPLETE_DATE" is not NULL then 'closed'
when "START_DATE" is NULL and "END_DATE" is NULL and "COMPLETE_DATE" is NULL then 'future' end as State,
GOAL as Goal,
BOARD_ID as OriginBoardId,
START_DATE as StartDate,
END_DATE as EndDate,
COMPLETE_DATE as CompleteDate
from "<DATABASE NAME>"."<SCHEMA NAME>"."<SPRINT TABLE NAME>";

Deploy the Jira Sprint Management SpotApp

After you complete the prerequisites, you are ready to deploy the Jira Sprint Management SpotApp and begin leveraging its pre-built content.

To deploy the Jira Sprint Management SpotApp, refer to Deploying SpotApps.

Jira Sprint Management SpotApp schema

The following table describes the schema for the Jira Sprint Management SpotApp.

The STATE column is visible through some ELT tools, such as Matillion, but not visible through other ELT tools, such as Fivetran. If the column does not appear on your ELT tool, do not map the column during the ELT mapping process.
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