Toggle navigation
Version
latest
6.3
6.2
6.1
6.0
5.3
ThoughtSpot Software
Release: 7.0
This is the latest version.
About this Release
Release notes
Fixed issues
Accessibility
Deprecation announcements
Downloads
Users
Introduction
Getting Started
User onboarding experience
Search Assist
Finding your way around
ThoughtSpot browser access
Your user preferences
Use tags to organize
Privileges
Understanding privileges
Granular access to Pinboards
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
Ask an Expert
Manage Ask an Expert requests
Retrieve Ask an Expert answers
Answer an Ask an Expert question
Results that are tables
Use keywords in search
Overview of keyword searches
Time series analysis
Search using growth over time
Using the in keyword for nested searches
Proximity search: 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
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
Pivot table
Sankey charts
Radar Charts
Candlestick Charts
Changing charts
Changing charts
Change axes options
Configure the columns
Rename columns and axes
Reorder the labels
Set the y-axis range
Hide and show values
Charts and tables with a very large number of data values
Change chart colors
Show data labels
Show data markers
Add regression lines
Display gridlines
Disable automatic selection of chart type
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
Follow a pinboard
Edit a pinboard
Delete a visualization
Pinboard filters
Linked Pinboard filters
Selective Pinboard filters
Answer Explorer
Schedule a pinboard job
Search actions within a pinboard
Copy a pinboard
Copy a pinboard or visualization link
Reset a pinboard visualization
Present a pinboard as a slideshow
Download as PDF
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
Best practices
Comparative Analysis
Custom SpotIQ analysis
Advanced R customizations
Insight feedback
SpotIQ preferences
Work with data
Understand data sources
Create and load CSV Files
Append data through the UI
View a data profile
Set your ThoughtSpot locale
Share your work
About sharing
Share a pinboard
Share answers
Share uploaded data
Request access
Revoke access (unshare)
Use SearchIQ
About SearchIQ
Use SearchIQ for natural searches
Teach SearchIQ your language
More help and support
Administration
Introduction to administration
Sign-in credentials for administration
Understand the architecture
Architectural components
Data caching
Authentication frameworks
Data and object security
Performance considerations
In-memory data compression
Admin Console
Overview
Managing users
Managing groups
Local authentication
Authentication through SAML
Authentication through Active Directory
Configure SSL
Configure a reverse SSH tunnel
Set the relay host for SMTP (email)
Customize ThoughtSpot Help
Customize actions
Style Customization
Configure NAS for backup storage
Manage and create snapshots
System Cluster Pinboard
System Alerts Pinboard
User Adoption Pinboard
Available cluster updates
Installation and setup
About installation and upgrades
Set your locale
Test connectivity between nodes
ThoughtSpot use agreement
Set the relay host for SMTP
Set up custom calendars
Configure internal authentication
Configure SSL
Configure SAML
Enable SSH through Active Directory
Integrate LDAP
About LDAP integration
Configure authentication through 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
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
Create a schema in SQL
Examples of schema creation
Upload a 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
Use the tsload connector
Delete a data source
Delete a data source (table)
Delete or change a table in TQL
Manage users and groups
Onboarding Users
Understand groups and privileges
Create, edit, or delete a group
Create, edit, or delete a user
Allow users to sign up
Security
Overview of security features
System security
Tools and processes
About third-party software
Installing third-party software
Data security
Data security
Share tables and columns
Share worksheets
Share Views
Share Pinboard
Share Answers
Revoke access (unshare)
Security for SpotIQ functions
Row level security (RLS)
About row level security (RLS)
How Rule-Based RLS works
Set Rule-Based RLS
ThoughtSpot Lifecycle
Encryption of data in transit
System administration
Overview of System administration
Send logs when reporting problems
Set up recording for Replay Search
Upgrade a cluster
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
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
Add or manage experts
Link tables using relationships
Link tables using relationships
Create a relationship
Delete a relationship
Use tags
Worksheets: improve Search
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
Create worksheet onboarding lessons with Search Assist Coach
Delete Worksheets or Tables
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
Refresh a view
Schedule view refreshes
Scriptability
Overview
Migrate or restore objects
ThoughtSpot Modeling Language
SpotApps
Set up SearchIQ
Enable SearchIQ
Optimize SearchIQ
Search IQ Optimization Steps
Enabling Columns in SearchIQ
Add Experts for SearchIQ
Train SearchIQ
Set entity categories for SearchIQ
Change SearchIQ mappings
Manage scheduled jobs
Job management (scheduled pinboards)
Scheduled pinboards management
Monitoring
Introduction to monitoring
System Information and Usage Pinboard
Data board
Cluster Manager board
Alerts and Events board
System worksheets
System Pinboards
Falcon monitoring Pinboards
Performance Tracking Pinboard
Troubleshooting
About 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
Mobile
Overview
Deploy
Install and set up
FAQ
Release notes
Embedding
Introduction to Embedding
Log in to the Linux shell using SSH
Log in credentials
Use the JavaScript API
SAML
About SAML
Configure SAML
Configure CA SiteMinder
Configure Active Directory Federated Services
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
Configure 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
Pinboard Data API
Metadata API
Session API
User API
Group API
Materialization API
Search Data API
Deploy
Overview
Amazon Linux 2 Support
Amazon Linux 2 overview
Amazon Linux 2 prerequisites
ThoughtSpot deployment artifacts for Amazon Linux 2
Online Amazon Linux 2 install
Offline Amazon Linux 2 install
Amazon Linux 2 upgrade
Adding new nodes to clusters in Amazon Linux 2
Packages installed with Amazon Linux 2
RHEL Support
RHEL overview
RHEL prerequisites
ThoughtSpot deployment artifacts for RHEL
Online RHEL install
Offline RHEL install
RHEL upgrade
Adding new nodes to clusters in RHEL
Packages installed with RHEL
Hardware appliance
Hardware appliance overview
Deploying on the SMC appliance
Deploying on the SMC appliance
Prerequisites
Hardware requirements
Connect the appliance
Configure nodes
Install cluster
Deploying on the Dell appliance
Deploying on the Dell appliance
Prerequisites
Hardware requirements
Connect the appliance
Configure management settings
Configure nodes
Install cluster
Cloud
Cloud overview
AWS
Configuration options
Set up AWS resources for ThoughtSpot
Prepare AWS VMs for ThoughtSpot
Configure ThoughtSpot nodes in AWS
Install ThoughtSpot clusters in AWS
Set up high availability
Back up and Restore using S3
Azure
Configuration options
Set up ThoughtSpot in Azure
Configure ThoughtSpot nodes in Azure
Install ThoughtSpot clusters in Azure
GCP
Configuration options
Set up ThoughtSpot in GCP
Configure ThoughtSpot nodes in GCP
Install ThoughtSpot clusters in GCP
Back up and Restore using GCS
VMware
Configuration overview
Set up ThoughtSpot in VMware
Configure ThoughtSpot nodes in VMware
Install ThoughtSpot clusters in VMware
Network ports
Consumption-based pricing
Contact support
Embrace
Overview
Snowflake
Overview
Add a connection
Modify a connection
Config OAuth
Best practices
Reference
Snowflake Partner Connect
Overview
Tutorials
Amazon Redshift
Overview
Add a connection
Modify a connection
Best practices
Reference
Google BigQuery
Overview
Prerequisites
Add a connection
Modify a connection
Reference
Azure Synapse
Overview
Add a connection
Modify a connection
Reference
Teradata
Overview
Add a connection
Modify a connection
Reference
SAP HANA
Overview
Add a connection
Modify a connection
Reference
Oracle ADW
Overview
Add a connection
Modify a connection
Reference
DataFlow
Overview
Key features
How DataFlow works
DataFlow home page
Requirements and guidelines
Database Connections
Supported database connections
Amazon Aurora
Overview
Connect
Sync
Reference
Amazon Redshift
Overview
Connect
Sync
Reference
Azure Synapse
Overview
Connect
Sync
Reference
Cassandra
Overview
Connect
Sync
Reference
Databricks Delta Lake
Overview
Connect
Sync
Reference
Denodo
Overview
Connect
Sync
Reference
Google BigQuery
Overview
Connect
Sync
Reference
Hive
Overview
Connect
Sync
Reference
IBM Db2
Overview
Connect
Sync
Reference
JDBC
Overview
Connect
Sync
Reference
MariaDB
Overview
Connect
Sync
Reference
MongoDB
Overview
Connect
Sync
Reference
MySQL
Overview
Connect
Sync
Reference
Netezza
Overview
Connect
Sync
Reference
Oracle
Overview
Connect
Sync
Reference
PostgreSQL
Overview
Connect
Sync
Reference
Presto
Overview
Connect
Sync
Reference
SAP Adaptive Server Enterprise
Overview
Connect
Sync
Reference
SAP HANA
Overview
Connect
Sync
Reference
SAP SQL Anywhere
Overview
Connect
Sync
Reference
SAS
Overview
Connect
Sync
Reference
SQL Server
Overview
Connect
Sync
Reference
Snowflake
Overview
Connect
Sync
Reference
Splice Machine
Overview
Connect
Sync
Reference
Teradata
Overview
Connect
Sync
Reference
File System Connections
Supported file system connections
Amazon S3
Overview
Connect
Sync
Reference
Apache Parquet
Overview
Connect
Sync
Reference
Azure Blob Storage
Overview
Connect
Sync
Reference
Files
Overview
Connect
Sync
Reference
Google Cloud Storage
Overview
Connect
Sync
Reference
HDFS
Overview
Connect
Sync
Reference
Application Connections
Supported application connections
Salesforce
Overview
Connect
Sync
Reference
REST API
Overview
Connect
Sync
Reference
Administration
Administration overview
Manage DataFlow users
DataFlow mail setup
Data Integration
Introduction to Data Integration
JDBC and ODBC setup prerequisites
ODBC driver 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
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
HA and resilience
Cluster replacement
Overview of cluster replacement
Mount a NAS file system
Configure disaster recovery
Reference
About this reference
Keyword reference
TQL reference
TQL service reference
tsload flag reference
tsload connector reference
tscli command reference
Date and time formats reference
Row level security rules reference
Formula function reference
Alert codes reference
User action codes reference
Stop word reference
Geo map reference
Glossary
Frequently asked questions
Deployment reference
Cable reference
Network ports
The nodes.config file
Parameters of nodes.config
Using the cluster create command
Parameters of cluster create
Site Survey
ThoughtSpot in Practice
Introduction
Reaggregation in practice
Teradata overview
Embrace enables you to connect to Teradata databases, to use your data in ThoughtSpot.
Add a connection
Modify a connection
Reference
Note:
Teradata Vantage version 16.20 or later is required.