How to Get Started with ThoughtSpot

To get started with ThoughtSpot, sign up for a free trial, connect a cloud data warehouse or upload a CSV, and use Spotter AI to ask questions about your data in plain English. No SQL required. Setup takes under 30 minutes. ThoughtSpot supports Snowflake, BigQuery, Databricks, Redshift, and a dozen other platforms, and connects directly to live data rather than storing copies.

What ThoughtSpot Is and Why It Matters in 2026

ThoughtSpot is a search-first business intelligence platform built on the premise that analysts and business users should be able to ask questions about data the same way they use a search engine. You type a question like "show me revenue by region last quarter" and ThoughtSpot returns a chart, table, or direct answer.

The platform launched its Spotter Agentic Analytics system in 2025, turning what was a search tool into a multi-step reasoning engine. Spotter can break a complex question into sub-tasks, query multiple tables simultaneously, surface the drivers behind a metric movement, and present findings without the user specifying each step. The system supports multi-turn conversations, meaning you can follow a first question with a second without rebuilding context each time.

This is a meaningful shift from traditional BI tools. Tableau and Power BI are strong at visualizing data that has already been modeled and dashboarded, but they require someone to build those dashboards first. ThoughtSpot lets teams skip that build phase and query live data directly. According to Luzmo's 2026 tool comparison, ThoughtSpot starts at $25 per user per month, compared to Tableau's $75 per Creator license, with the key differentiator being ThoughtSpot's ability to support non-technical users without a modeling prerequisite.

For ops managers, analysts, and founders who work with data but don't code, this changes the dependency chain. Rather than waiting for a data team to build a specific report, you can connect your warehouse and start asking questions the same day.

Before You Start: What You Need

Before creating a ThoughtSpot account, have one of the following ready:

A cloud data warehouse account (Snowflake, BigQuery, Databricks, Amazon Redshift, Microsoft Azure Synapse, Starburst, or Oracle Autonomous Data Warehouse) with credentials that have read access to the relevant schemas and tables. Alternatively, you can start immediately with a CSV file or a Google Sheets URL if you do not have a warehouse set up.

ThoughtSpot does not store your data. It connects directly to your warehouse and queries it live, so data does not move and the access controls from your warehouse continue to apply.

Step 1: Sign Up for a Free Trial

Go to thoughtspot.com and click the "Free Trial" button. You will be asked to select which cloud data platform you use. If you are just exploring, you can skip this step and start with the pre-loaded sample datasets.

After submitting the registration form, you will receive an activation email from ThoughtSpot. Click "Activate Spotter" in that email. You will land on a setup page where you create your password and access the platform for the first time.

The free trial gives full access to Spotter AI with sample retail and sales datasets pre-loaded, so you can run queries immediately without connecting anything external.

Step 2: Connect Your Data Source

Once logged in, click Connect Data from the top navigation bar, or select Try Spotter on your own data from the welcome screen.

ThoughtSpot offers three connection paths:

CSV or Google Sheet. Upload a file or paste a Google Sheets URL. ThoughtSpot infers the schema automatically. A standard CSV with a few thousand rows loads in under a minute. This is the fastest path for a first test.

Cloud data warehouse. Select your platform from the supported list. You will be prompted for connection credentials: host URL, warehouse name, database name, schema, username, and either a password or an OAuth token depending on your warehouse setup. Snowflake and BigQuery connections follow well-documented patterns in the official ThoughtSpot documentation.

On-premise and hybrid connectors. ThoughtSpot also supports Starburst, Oracle Autonomous Data Warehouse, and SQL Server for teams running non-cloud or hybrid infrastructure.

After entering credentials, ThoughtSpot runs a connection test. If it passes, it shows the available schemas and tables. Select the tables you want to make queryable and click Create Connection. Connection creation takes one to three minutes for most configurations.

Step 3: Create a Data Model (Optional but Recommended)

Before querying, you can improve Spotter's accuracy by adding business context through a worksheet. In the Data tab, select your connection, then choose Create Worksheet.

In the worksheet editor, you can rename columns from technical names to plain English (for example, rename mrr_usd_net to "Net MRR"), define joins between tables, set number formatting, configure date display preferences, and add synonyms for common terms your team uses.

This step is optional. Spotter will work against raw column names without a worksheet, but accuracy improves significantly once fields are labeled in plain language. If you type "what was our churn last month" and ThoughtSpot returns the wrong metric, the most common fix is labeling the relevant column and adding "churn" as a synonym.

For a first test, skip the worksheet and query the raw connection directly.

Step 4: Run Your First Spotter Query

Click Spotter in the top navigation or select your connection from the home screen.

The Spotter interface is a chat-style input bar. Type a question in plain English:

• "Show me sales by product category for Q1 2026"
• "Which customers had the highest average order value in the last 90 days?"
• "What drove the drop in revenue in March?"

ThoughtSpot parses the question, maps it to your schema, generates a query, executes it against your live warehouse, and returns a result. For standard aggregation questions on a Snowflake or BigQuery connection, responses typically come back in three to ten seconds.

For questions with ambiguous terms (for example, if "revenue" maps to more than one column), Spotter will ask a clarifying question before running. You can answer in plain English without specifying column names.

The result appears as a chart by default. You can toggle to a table view, change the chart type, or ask a follow-up question in the same conversation without starting over.

Step 5: Save and Share Insights

Once you have a result worth keeping, click Pin to add it to a Liveboard. Liveboards are ThoughtSpot's equivalent of dashboards. You can create a new one or pin to an existing board.

Liveboards query live against your warehouse on every open. There is no manual refresh step, and the data is always current.

To share, click the Share button on any Liveboard or individual answer. You can share with specific users within your ThoughtSpot organization or generate a public link if your instance allows it.

What SpotIQ Does

SpotIQ is ThoughtSpot's automated insight engine. It scans data in the background and surfaces anomalies, trends, and correlations you did not explicitly ask for.

To trigger it, click SpotIQ Analysis on any chart or table. ThoughtSpot will run a deeper scan and return a ranked list of findings. For example: "Revenue for the Enterprise segment grew 23% faster than the overall average in Q1." This is useful immediately after connecting a new dataset. Running SpotIQ on your most important table gives a fast overview of what patterns exist before you start writing specific queries.

Pricing

ThoughtSpot's paid plans start at $25 per user per month. The free trial includes full access to Spotter and the sample datasets, with a 14-day window to connect your own data. There is no free tier for production use, but the trial is sufficient to validate whether the platform works for your specific data before committing to a plan.

Summary

ThoughtSpot gets you from sign-up to a live query in under 30 minutes if you have warehouse credentials ready. The biggest accuracy gain comes from spending 15 minutes labeling worksheet columns in plain English after the initial connection. Spotter's natural language engine is strong on standard aggregation and trend questions, and the SpotIQ analysis is a practical shortcut for exploratory work on datasets you have not dug into before.