back to catalog
works in free trial | Built on

Okta Usage Get code

Code by ThoughtSpot

Includes the following:

Snowflake DDL

Snowflake DDL (okta_ga.sql) for creating tables and loading csv via snowsql.


  • Okta Sys Log Events Table


  • Okta Login History
  • Okta Application History
  • Pinboard_Manifest.yaml

Rate this code

Thank you for rating this code!

Installation instructions


The Okta Spot is built upon the data sourced as a csv from the System Log UI. This data can also be programmatically sourced via the API.

  • System Log UI
  • System Log API The Okta System Log records system events that are related to your organization in order to provide an audit trail that can be used to understand platform activity and to diagnose problems. The Okta System Log API provides near real-time, read-only access to your organization's system log and is the programmatic counterpart of the System Log UI.

Retrieve and Prep data

  • Use the okta_ga.sql DDL script to create the necessary staging table (syslog) in your data warehouse.
  • Load your csv data file into the "syslog" table

Connect with Thoughtspot and Import TML

Log into your ThoughtSpot instance and create an Embrace connection to each of the "syslog" table.

Combine all liveboard TML files into a ZIP file:

  • pinboard_liveboard.yaml
  • Okta Application Usage.pinboard.tml
  • Okta Login History.pinboard.tml
  • Import the TML (oktatmlblocksworksheet.tml) for the worksheets and verify that it has all been imported without any errors.
  • Import the zipped file for the liveboards and verify that it has all been imported without any errors.

Liveboards Included

Login History

Application History

Get code