back to catalog
works in free trial | Built on

ServiceNow Incident Management Get code

Code by ThoughtSpot

Incident Management trends and KPI’s are now accessible via search and point-and-click interactive visualizations. The ServiceNow Incident Management TML Blocks is built on top of a subset of the native ServiceNow data model. This means that in order to get up and running, you simply need to transfer your data, as-is, into a Cloud Data Warehouse. Once the data is stored in a CDW such as Snowflake, RedShift or GBQ, just use ThoughtSpot Embrace to connect to the data and import the ServiceNow Incident Management SpotApp.

Rate this code

Thank you for rating this code!

Installation instructions

Create the New CDW Connections

  1. Create new embrace connection
  2. Select ServiceNow tables on the cloud data warehouse
  3. Tables from the ServiceNow schema that are required for Spotapps


  • task
  • incident
  • incident_task
  • problem
  • Problem_task


  • cmn_location
  • core_company
  • sys_user
  • sysusergroup

Note: These are the original table names from ServiceNow

Export Connection YAML File and TML Files

  • Select new Embrace Connection with ServiceNow tables
  • Remap Connection
  • Download YAML file
  • Navigate to the Data Tab
  • Select the ServiceNow tables
  • Click on Export TML

Run Script

  • Unzip the spotapp zip file
  • Copy the connection yaml file into the folder titled “InputConnectionYAML”
  • Copy the table TML files into the folder titled “InputTableTML”
  • Run the script through the terminal For macOS, copy folder to ‘Documents’ folder cd ~/Documents/Spotapps python3

Column Description from the Mapping CSV

  • A - User friendly column names in the Spotapp worksheet.
  • B, C, D, E - Original table and columns, join table and column names are listed from the original ServiceNow schema.
  • F, G - Details about the joins in the Spotapp worksheet (join type and join required for spotapp to work).
  • H, I - Shows the Table and Column names from the user’s CDW.
  • J, K - Shows the tables and columns that are required for spotapp to work; these tables and columns should be present in the user’s CDW.
  • L, M - the tables and columns that are missing in the user’s CDW are indicated by Y. If column value is Y, then it indicates that our script did not find the table/column in the user’s connection.
  • N, O - Mapping table and mapping column to be set by the user. When we find a missing column and indicate it in L, M by setting it to Y, we expect a value in these columns to point us to the corresponding columns in the user’s CDW.
  • Example: we did not find ‘task’ table in the user’s CDW connection, user has renamed table to ‘servicenowtask’; then we need the value in column N to be set to ‘servicenowtask’ wherever we see a Y for the task table (screenshot on the next slide).

Import TML Files

  • Import the files containing TML for the worksheets and verify that it has all been imported without any errors.
  • Import the files for the liveboards and verify that it has all been imported without any errors.

Liveboard Screenshots

Significant Events Examinations

Incident Management Overview

Incident Management Performance

Get code