• Version 5.1 Guides
• Users
  • Introduction
  • Getting Started
    • Finding your way around
    • ThoughtSpot browser access
    • Your user preferences
    • Understanding privileges
    • Use stickers to organize
  • Use Search
    • What are searches and answers?
    • Search basics
      • Start a new search
      • Choose a data source
      • Search bar features
      • Search suggestions
      • Search results and column types
      • Last data refresh time
      • Work with Answers
    • Results that are tables
    • Use keywords in search
      • Overview of keyword searchess
      • Time series analysis
      • Search using growth over time
      • Proximity searches "near" and "farther than"
    • Work with filters
      • Understand filters
      • Add a filter to a table
      • Add a filter to a chart
      • Create a bulk filter
      • Delete a filter
      • Filter on null, blank, or empty values
    • Other search actions
      • Change result display options
      • Show underlying data
      • See the search behind a result
      • Apply conditional formatting to a table
      • Download your search
      • Replay search
  • Work with charts
    • Understand charts
    • Chart types
      • Column charts
      • Bar charts
      • Line charts
      • Pie charts
      • Area charts
      • Scatter charts
      • Bubble charts
      • Pareto charts
      • Waterfall charts
      • Treemap charts
      • Line column charts
      • Funnel charts
      • Geo charts
      • Sankey charts
      • Pivot table
    • Changing a chart
      • Reorder the labels
      • Set the y-axis range
      • Hide and show values
      • Change chart colors
      • Additional chart options
      • Zoom into a chart
  • Work with formulas
    • Understand formulas
    • Add a formula to a search
    • View or edit a formula in a search
    • Aggregate formulas
      • Overview of aggregate formulas
      • Cumulative functions
      • Moving functions
      • Flexible aggregation functions (group aggregate and filters)
      • Grouping functions
      • Filtered aggregation functions
    • Conversion functions
    • Date functions
    • Percent (simple number) calculations
    • Formula operators
    • Nested formulas
    • Formulas for chasm traps
  • Use pinboards
    • Basic pinboard usage
    • Edit a pinboard
    • Pinboard filters
    • Schedule a pinboard job
    • Search actions within a pinboard
    • Copy a pinboard
    • Copy a pinboard or visualization link
    • Reset a pinboard visualization
    • Start a slideshow
  • Use custom R scripts
    • About R in ThoughtSpot
    • Create and share R scripts
    • Run prebuilt R scripts on answers
    • Save and share R visualizations
  • SpotIQ
    • What is SpotIQ
    • 101: Load and analyze data
    • 101: Review and save insights
    • 101: Do more with SpotIQ
    • Best SpotIQ Practices
    • Custom SpotIQ analysis
    • Advanced R Customizations
  • Work with data
    • Understand data sources
    • Create and load CSV Files
    • Append data through the UI
    • View a data profile
    • Date and currency format settings
    • Share your work
      • About sharing
      • Share a pinboard
      • Share answers
      • Share uploaded data
      • Revoke access (unshare)
  • Use SearchIQ
    • About SearchIQ
    • Use SearchIQ for natural searches
    • Teach SearchIQ your language
  • Slack and ThoughtSpot
    • Slack and Spot
    • How to use Spot
  • More help and support
• Administration
  • Introduction to administration
  • Login credentials for administration
  • Understand the architecture
    • Architectural components
    • Data caching
    • Authentication frameworks
    • Data and object security
    • Performance considerations
  • Installation and setup
    • About installation and upgrades
    • Set your locale
    • Test connectivity between nodes
    • Set the relay host for SMTP
    • Set up a fiscal calendar year
    • Configure SSL
    • Configure SAML
    • Enable Active Directory based access
    • Integrate LDAP
      • About LDAP integration
      • Configure LDAP for Active Directory
      • Add the SSL certificate for LDAP
      • Test the LDAP configuration
      • Sync users and groups from LDAP
    • Configure NAS file system
    • Set up monitoring
    • Configure support services
    • Network ports
    • Configure load balancing and proxies
    • Customize ThoughtSpot Help
    • Customize look and feel
    • Enable SearchIQ
    • Add the Slack integration
  • Load and manage data
    • Introduction to data management
    • Configure casing
    • Load CSV files with the UI
    • How to view a data schema
    • Plan the schema
      • About schema planning
      • Data types
      • Constraints
      • Sharding
      • Chasm traps
    • Build the schema
      • Schema building overview
      • Connect with TQL and create a schema
      • How to write a SQL script
      • Schema creation examples
      • Upload an SQL script
    • Change the schema
      • How to change a schema
      • Convert column data type
    • Load bulk data
      • Import CSV files with tsload
      • Use a script to load data
    • Delete a data source
      • Delete a data source (table)
      • Delete or change a table in TQL
  • Improve search with modeling
    • About data modeling
    • Change a table's data model
    • Edit the system-wide data model
    • Data model settings
      • Overview of the settings
      • Set column name, description, and type
      • Set additive and aggregate values
      • Hide a column or define a synonym
      • Set columns to exclude from SpotIQ analyses
      • Manage suggestion indexing
      • Add a geographical data setting
      • Set number, date, currency formats
      • Change the Attribution Dimension setting
      • Set entity categories for SearchIQ
    • Link tables using relationships
      • Link tables using relationships
      • Create a relationship
      • Delete a relationship
    • Use stickers
  • Simplify search with worksheets
    • Create and use worksheets
    • Edit a worksheet
    • Create a formula in a worksheet
    • Create worksheet filters
    • How the worksheet join rule works
    • Change join rule or RLS for a worksheet
    • Create a join relationship
    • Modify joins between worksheet tables
    • Delete a worksheet or table
  • Work with views
    • Understand views
    • Save a search as a view
    • Create a search from a view
    • View example scenarios
    • About materialized views
    • Materialize a view
    • Dematerialize a view
    • Schedule view refreshes
  • Manage users and groups
    • Understand groups and privileges
    • Create, edit, or delete a group
    • Add, edit, or delete a user
  • Manage jobs
    • Job management (scheduled pinboards)
    • Scheduled pinboards management
  • Security
    • Overview of security features
    • System Security
    • Data security
      • Data security
      • Share tables and columns
      • Share worksheets
      • Share a pinboard
      • Security for SpotIQ functions
      • Revoke access (unshare)
    • Row level security (RLS)
      • About row level security (RLS)
      • How Rule-Based RLS works
      • Set Rule-Based RLS
    • ThoughtSpot Lifecycle
  • System administration
    • Overview of System administration
    • Send logs when reporting problems
    • Set up recording for Replay Search
  • Monitoring
    • Introduction to monitoring
    • Overview board
    • Data board
    • Cluster Manager board
    • Alerts and Events board
    • System worksheets
    • System pinboards
  • Backup and restore
    • Understand the backup strategies
    • Understand backup/snapshot schedules
    • Work with snapshots
    • Work with backups
      • Understand backup modes
      • Create a manual backup
      • Configure periodic backups
      • About restore operations
  • Troubleshooting
    • Get your configuration and logs
    • Upload logs to ThoughtSpot Support
    • Network connectivity issues
    • Check the timezone
    • Browser untrusted connection error
    • Characters not displaying correctly
    • Clear the browser cache
    • Cannot open a saved answer that contains a formula
    • Data loading too slowly
    • Search results contain too many blanks
• Data Connect
  • Introduction to Data Connect
  • Prerequisites and Architecture
  • Set up ThoughtSpot Data Connect
  • Work with Data Sources
    • Add a new data source
    • About changing the schema (DDL)
    • About incremental data loads
    • Data sources management
  • Changing the setup
    • Overview of best practices
    • Edit a connection
    • Delete a connection
    • Delete a data source
    • Stop a scheduled job from running
    • Change sharding for a data source
    • Change a column data type
    • Add a column to an existing data source
    • Remove a column from an existing data source
    • Add/remove columns in a loaded table
  • Reference
    • Login for administration
    • Best practices
    • Connectors reference
• Application Integration
  • Introduction
  • Log in to the Linux shell using SSH
  • Log in credentials
  • Get the JavaScript API
  • SAML
    • About SAML
    • Configure SAML
    • Configure CA SiteMinder
    • Active Directory
      • Configure Active Directory Federated Services
      • Initialize the Identity Provider Metadata
      • Initialize the Service Provider Metadata
      • Test the ADFS Integration
  • REST API
    • About the REST API
    • Calling the REST API
    • REST API pagination
    • Use the REST API to get data
    • Use the Embedded Search API
    • Use the Data Push API
  • Embed ThoughtSpot
    • Understand embedding
    • Embed pinboard or visualization
    • Authentication flow with embed
    • Full application embedding
    • Configured trusted authentication
  • Runtime Filters
    • About Runtime Filters
    • Apply a Runtime Filter
    • Runtime Filter Operators
  • Style Customization
    • Customize the application style
    • Upload application logos
    • Set chart and table visualization fonts
    • Choose a background color
    • Select chart color palettes
    • Change the footer text
  • API Reference
    • Introduction
    • pinboarddata API
    • metadata API
    • session API
    • user API
    • group API
• Node Setup
  • Overview
  • Hardware appliance
    • Hardware appliance overview
    • Supported hardware
    • Cable networking
    • Set up and start the appliance
  • AWS node
    • AWS cluster overview
    • Configuration options
    • Set up AWS for ThoughtSpot
  • Azure node
    • Azure cluster overview
    • Configuration options
    • Set up Azure for ThoughtSpot
  • GCP node
    • GCP cluster overview
    • Configuration options
    • Set up GCP for ThoughtSpot
  • VMware node
    • Configuration overview
    • Set up VMWware for ThoughtSpot
  • Network ports
  • Contact support
• Data Integration
  • Introduction to Data Integration
  • Login credentials for administration
  • Use the ODBC client
    • ODBC driver overview
    • ODBC on Windows
      • Install the ODBC driver on Windows
      • Configure multiple connections on Windows
      • Deploy SSL with ODBC on Windows
      • Set up the ODBC Driver for SSIS
    • Install the ODBC Driver on Linux
    • Install the ODBC Driver on Solaris
    • Best Practices for Using ODBC
  • JDBC Driver Client
    • JDBC Driver Overview
    • Use the JDBC Driver
  • Set up the JDBC Driver for Pentaho
  • Troubleshooting
    • Troubleshooting Data Integrations
    • Enable ODBC Logs
    • Enable JDBC Logs
    • Schema not found error with ODBC
    • How to improve throughput
    • ODBC tracing on Windows
  • Reference
    • Supported SQL commands
    • Connection configuration
• Disaster Recovery
  • About disaster recovery
  • Disk failure
  • Node failure
  • Cluster replacement
    • Overview of cluster replacement
    • Mount a NAS file system
    • Configure disaster recovery
• Reference
  • About this reference
  • Keyword reference
  • TQL reference
  • tsload flag reference
  • tscli command reference
  • Date and time formats reference
  • Row level security rules reference
  • Formula function reference
  • Alert codes reference
  • User action codes reference
  • Error codes reference
  • Frequently asked questions
• About this Release
  • Help Center
  • Release notes
  • Downloads
  • Glossary
  • Topic index

Welcome to ThoughtSpot Documentation

VIDEOS AND TUTORIALS

Videos

SpotIQ tutorial

Getting started

USER AND ADMIN GUIDES

User Guide

Reference Guide

Administration Guide

DATA AND APP SETUP

Node Setup Guide

Data Connect Guide

Data Integration Guide

Application Integration Guide

Disaster Recovery

COMMUNITY NEWS

Community

SpotOn Webinars

5.1 Release Notes