BestOnline.ToolsBestOnline.Tools
Data analysis

ThoughtSpot

ThoughtSpot review: Spotter AI analytics and live dashboards

ThoughtSpot review: explore Spotter analytics, live dashboards, warehouse connections, pricing and alternatives for business reporting and embedded analytics.

AI analyticsLive dashboardsEmbedded analytics

Paid plansAccount required

Product previewView original
ThoughtSpot’s Spotter interface showing a sales-by-region chart in a product demonstration.
ThoughtSpot’s Spotter interface showing a sales-by-region chart in a product demonstration.ThoughtSpot
Access
Paid access
Example plan
USD 600 / user / yearPro user: annual subscription
Available on
Web, API
OVERVIEW

Business intelligence built around questions

ThoughtSpot is a business intelligence platform for teams that want to ask questions of company data as well as read dashboards. Spotter is its AI analyst: a question about sales, customers or operations can return a chart, table or explanation, with follow-up questions continuing the analysis.

Its strongest fit is a business with warehouse data and shared definitions of its metrics. People can investigate those metrics without writing every query themselves, while the data team maintains the models behind them. That preparation still matters: conversational answers do not replace clear measures, relationships and access rules.

Live connections include Snowflake, Databricks, BigQuery and Amazon Redshift, alongside other supported databases. ThoughtSpot queries connected data directly. Joins must stay within one connection; connecting several warehouses does not create unrestricted joins between them.

Spotter 3 adds cross-model search that can query several accessible models and combine their findings. This optional capability currently answers in English text summaries rather than a single combined chart. It respects existing row and column permissions, and administrators must enable it.

Spotter 3 also has Search and Research modes for short questions and more involved investigations. Configured connectors can bring context from Slack, Jira or Confluence into a conversation and send results back. Connectors are listed as early access, need administrator setup and user authentication, and follow configured tool permissions.

For a small ad hoc analysis, Spotter accepts CSV uploads of up to 5 MB each, with ten files per message. These files belong to the conversation rather than a permanent warehouse model. Their lifetime follows saved-chat settings; with saved conversations disabled, they persist for six hours.

Saved answers become reusable charts and tables on Liveboards. Teams can filter and drill into these dashboards, share view or edit access, and export a PDF when downloads are enabled. TML exports serve a different purpose: moving analytics definitions between environments.

The main trade-off is the boundary between conversational exploration and detailed report editing. Chat does not change chart colors, axes or label visibility, and it cannot change parameters. More advanced visualization work uses the editor. Spotter Classic, Agent and Spotter 3 also have different capabilities.

ThoughtSpot is a good candidate for companies opening governed reporting to business teams or embedding it in a product. Hex is worth considering for SQL and Python notebook work; Power BI suits Microsoft reporting environments. ThoughtSpot’s APIs and Visual Embed SDK support product integration under the relevant embedded offer.

Best for

  • Business teams exploring shared company metrics
  • Data teams maintaining warehouse reporting
  • Product teams embedding analytics

Limitations

Spotter versions differ. Cross-model answers are English text summaries, not combined charts. Chart styling needs the editor, and chat cannot change parameters. Queries, rows and connector access depend on your plan and configuration.

WHAT YOU CAN DO

ThoughtSpot features

Conversational analytics

Ask about business metrics, refine the question and switch between chart and table answers.

Live warehouse connections

Query supported databases including Snowflake, Databricks, BigQuery and Redshift; joins remain within a connection.

Cross-model search

Spotter 3 can combine results from permitted models into an English text summary when this option is enabled.

Search and Research modes

Spotter 3 supports direct questions and more involved investigations with visible analysis steps.

Interactive Liveboards

Group saved answers into dashboards with filtering, drill-down and separate view or edit access.

CSV analysis

Analyze files of up to 5 MB each, with ten files per message and retention tied to conversation settings.

Connected business context

Early-access Spotter 3 connectors support external context and actions after administrator setup and user authentication.

Embedded analytics

Add dashboards, search and agent experiences to applications with APIs and the Visual Embed SDK.

PLANS & PRICING

ThoughtSpot pricing

Pro costs $50 per user/month billed annually, with 25 monthly Spotter queries per user. Usage-based Pro starts as low as $0.10 per credit; contract terms apply. Enterprise and embedded analytics have separate offers. Unlimited LLM tokens still sit within subscription limits, and your own LLM provider may charge separately.

Example plans.

Pro user: annual subscription

USD 600 / user / year

Current documented product

Billed annually.

Plan details

USD 50 per user/month billed annually; 25 Spotter queries per user/month. Pro user and row limits apply.

Pricing updated 2026-10-10. Prices may change.View current pricing →
Technical specifications

Data analysis

FeatureThoughtSpot
Data inputs and connections
Live warehouse connections including Snowflake, Databricks, BigQuery and Redshift; joins cannot span separate connections.Configured data connections
Analysis workflow
Conversational charts, tables and explanations; optional Spotter 3 cross-model search synthesizes permitted models as English text summaries.Enabled agent version and cross-model configuration
Charts and reproducible outputs
Saved Answers and shared Liveboards; PDF dashboard reports when downloads are enabled, plus TML exports for analytics definitions.Liveboard and data-source permissions
Data permission controls
Liveboards have view/edit access; filtering requires source access. Cross-model search respects existing model, row and column permissions.Configured workspace and model access
Data and compute limits
Chat cannot change chart colors, axes, labels or parameters. Cross-model summaries are English-only; supported features vary by agent version.Enabled Spotter version
Maximum dataset size (rows)
250000000Pro plan allowance; not a per-file or universal dataset limit
API access
SupportedDeveloper APIs and Visual Embed SDK; applicable embedded licensing
MORE AI TOOLS

ThoughtSpot alternatives

Power BI offers Microsoft reporting, Hex combines notebooks with data apps, and Qlik is another established business analytics platform.

Qlik Cloud Analytics

Qlik Cloud Analytics

Another established business analytics platform.

Power BI with Copilot

Power BI with Copilot

Microsoft reporting built around semantic models; Copilot requires eligible capacity and configuration.

Hex

Hex

SQL and Python notebooks, shared data apps and conversational analysis for business teams.

COMMON QUESTIONS

ThoughtSpot FAQs

What is ThoughtSpot used for?

ThoughtSpot provides business intelligence through search, Spotter AI analytics and live dashboards. Companies use it for warehouse reporting, shared metrics and analytics embedded in their own applications.

How much does ThoughtSpot cost?

Pro is $50 per user/month billed annually, including 25 monthly Spotter queries per user. Usage-based Pro advertises credits from $0.10; Enterprise and embedded offers have separate terms.

Does unlimited LLM usage mean unlimited ThoughtSpot queries?

No. ThoughtSpot does not meter LLM tokens, but subscription limits still govern platform use. Fees from your own LLM provider may apply separately.

Can ThoughtSpot analyze several data models?

Spotter 3 can synthesize findings across accessible models when cross-model search is enabled. Combined answers are currently English text summaries. This does not enable joins across separate warehouse connections.

Can I upload a spreadsheet to Spotter?

Spotter accepts CSV files up to 5 MB each, with ten per message. They stay with the conversation; retention depends on saved-chat settings rather than becoming permanent warehouse data.

Can Spotter change chart formatting or parameters?

Chat cannot change chart colors, axes or data-label visibility, and it cannot change parameters. Use the chart editor for detailed presentation work. Capabilities also vary by Spotter version.

Can I embed ThoughtSpot in my own product?

Yes. The developer platform provides APIs and a Visual Embed SDK for dashboards, search and agent experiences. Embedded analytics is a separate offer with its own licensing and access requirements.

What are the best ThoughtSpot alternatives?

Power BI, Hex and Qlik are relevant alternatives. Power BI focuses on Microsoft reporting, Hex combines SQL and Python notebooks with shared apps, and Qlik offers an established business analytics platform.

Is this your product? Claim this page to update your listing.