# ThoughtSpot — Business Intelligence & Dashboards

ThoughtSpot by ThoughtSpot, Inc. holds a panel rating of 2/5 from 6 AI judges (category median 2.5/5), as of 2026-11-19. Provenance: provenance unknown; sovereignty: not determined.

- Vendor: ThoughtSpot, Inc. (https://www.thoughtspot.com)
- Category: [Business Intelligence & Dashboards](https://whats-best.ai/software/business-intelligence.md)
- Provenance (editorial classification): provenance unknown
- Canonical page: https://whats-best.ai/software/business-intelligence/thoughtspot
- Alternatives: https://whats-best.ai/software/business-intelligence/thoughtspot/alternatives ([markdown](https://whats-best.ai/software/business-intelligence/thoughtspot/alternatives.md))
- Data as of: 2026-11-21 · evaluated 2026-11-19 · oldest source captured 2026-11-17

**AI-generated.** Every score, rationale and verdict here is written by a panel of AI judges from public evidence — an analysis, not a hands-on test. Every fact quotes the vendor page it was read from. No score can be bought. How scores are made: https://whats-best.ai/methodology

## At a glance

- Vendor: ThoughtSpot, Inc.
- Headquarters: Not stated on the vendor’s pages as of 17 Nov 2026
- Data hosting: Not stated on the vendor’s pages as of 17 Nov 2026
- Free plan: Not stated on the vendor’s pages as of 17 Nov 2026

## The panel's verdict

ThoughtSpot is a search-based business intelligence tool, and the captured documentation is deepest where analysts and administrators work. Self-service and modelling is the strongest criterion at 6: business users search in their own words, analysts build reusable datasets through a SQL editor, and dbt MetricFlow models import one way — that path is early access behind a support contact, capped at dbt versions 1.7 and earlier, and supports only Simple and Ratio metrics. Governance and portability scores cluster at 5-6, on row-level security scaling to thousands of groups, strict enforcement on by default, and more than fifty audit event types streamable to a SIEM every five seconds and retained thirty days. Data connectivity and sharing and embedding both sit at 4 — Snowflake is the one deeply documented connection, and alerting down to every N minutes is the strong part of sharing. Dashboards score 4-5, with only KPI charts and pivot tables documented. Sovereignty scores 1-2: a US legal address is the proven fact, with no public hosting, subprocessor or data processing agreement information. No price appears on any captured page.

**Speaks for it:**
- Snowflake live connection documented in depth, with AWS PrivateLink, GCP Private Service Connect, OAuth variants and CSV upload
- Row-level security scales to thousands of groups, with strict enforcement on by default and a single Liveboard able to show each group different data
- More than fifty audit event types stream to Splunk, Datadog, Azure Log Analytics or HTTP every five seconds, with an API to pull them
- Alerts run hourly, daily, weekly, monthly or every N minutes, with group subscribers, custom messages and webhooks
- Pivot tables support right-click drill-down and heatmap mode up to 100,000 rows, and export to XLSX with formatting retained

**Held against it:**
- The dbt MetricFlow integration is early access behind a support contact, limited to dbt versions 1.7 and earlier and Simple and Ratio metrics, with no auto-refresh and no sync of edits back to dbt
- Beyond KPI charts and pivot tables we found no public information on maps, dashboard-wide filters, mobile display or localised number and date formats
- We found no public information on hosting location, subprocessors or a data processing agreement; the only proven fact is the legal address at 444 Castro Street, Suite 1000, 94041 Mountain View, US
- No published connector list appears, Redshift, Databricks and BigQuery are named only through the dbt certification, and no refresh interval is stated
- No price, tier or seat model appears on any captured page; the only traces are free-trial and Team Edition audit events

**Best for:**
- You run Snowflake and need live queries over private networking such as AWS PrivateLink or GCP Private Service Connect
- You must show each customer, team or group its own figures from a single Liveboard, with row-level security scaling to thousands of groups
- Your security operations team wants audit events streamed to its own SIEM — Splunk, Datadog, Azure Log Analytics or HTTP — every five seconds
- Your analysts define metrics once in dbt MetricFlow (version 1.7 or earlier) and want them importable into a tool with a SQL editor for reusable datasets

**Avoid if:**
- Your dbt project runs above version 1.7 or uses metric types beyond Simple and Ratio
- You need changes in dbt to appear automatically in the tool, or edits made in the tool to flow back to dbt
- You must keep audit logs longer than the 30 days the system retains them and cannot stream them to your own SIEM
- Your pivot analyses regularly exceed the documented 100,000-row limit

## Scores by judge and criterion

Scores out of 5, each judge scoring independently against the published rubric (v1). "n/r" = not rated: the vendor publishes no price, or the judge found no public information on that criterion.

| Criterion | The Finance Controller | The Managing Director | The Data Analyst | The IT Administrator | The SaaS Product Lead | The Skeptic |
| --- | --- | --- | --- | --- | --- | --- |
| Data sources, connectors & refresh | 2/5 | 2/5 | 2/5 | 2/5 | 2/5 | 2/5 |
| Dashboards, charts & interactivity | 2/5 | 2.5/5 | 2/5 | 2.5/5 | 2/5 | 2.5/5 |
| Self-service analysis & shared metrics | 3/5 | 3/5 | 3/5 | 3/5 | 3/5 | 3/5 |
| Sharing, scheduled reports & embedding | 2/5 | 2/5 | 2/5 | 2/5 | 2/5 | 2/5 |
| Access control, administration & portability | 2.5/5 | 3/5 | 3/5 | 3/5 | 3/5 | 2.5/5 |
| European sovereignty | 0.5/5 | 0.5/5 | 0.5/5 | 0.5/5 | 1/5 | 0.5/5 |
| Pricing transparency | n/r | n/r | n/r | n/r | n/r | n/r |
| **Weighted verdict** | **2/5** | **2/5** | **2.5/5** | **2/5** | **2/5** | **2/5** |

### The judges

- **The Finance Controller** (v1.0): Head of controlling at a 250-person machine builder in Baden-Württemberg. Closes the month from DATEV, the ERP, the CRM and a dozen Excel files that colleagues still mail around, and spends two days a month copying numbers into the management report. Wants the sources connected and refreshed on a schedule, one definition of contribution margin on every page, a report that prints cleanly for the advisory board, and data that stays where the auditors expect it.
- **The Managing Director** (v1.0): Runs a 40-person service company with HubSpot, an online accounting tool, a help desk and a project management app, and no one whose job is data. Wants revenue, pipeline, utilisation and open tickets on one screen in the office and on their phone, set up in an afternoon from ready-made connectors, a weekly summary in the inbox on Monday morning, and a price that does not double when the whole team wants to look.
- **The Data Analyst** (v1.0): The first data hire at a Hamburg e-commerce scale-up, with orders, marketing spend and customer data landing in a PostgreSQL warehouse every night. Answers the same question three times a week because every department computes revenue differently. Wants a SQL editor and a query builder for colleagues, metrics defined once in a model that lives in Git, natural-language questions that show the query they ran, and a way out that does not mean rebuilding every dashboard.
- **The IT Administrator** (v1.0): IT lead at a mid-sized healthcare supplier whose reports touch customer, pricing and employee data. Is asked to approve a BI tool after a department has already started a trial. Reads where extracts and caches are stored, whether the tool reaches the ERP database through a gateway or wants it opened to the internet, whether sales sees only its own region, and whether single sign-on and an audit log come with the plan or behind a sales call. Prefers an edition they can run themselves.
- **The SaaS Product Lead** (v1.0): Product lead at a Vienna software company selling fleet management to 600 business customers, each of whom asks for reports the team keeps building by hand. Wants dashboards embedded in the product under its own brand, every customer seeing only their own rows, customers building their own views without a ticket, and an embedding licence whose cost they can put into the product's price before signing.
- **The Skeptic** (v1.0): Has seen "connect any data source" on a tool with eight connectors and a CSV upload, "self-service" that ends with every department defining revenue its own way, "free viewers" that need a paid licence to open a shared link, and "AI insights" that never show the query. Asks where the extracts are stored, whether dashboards and definitions can be exported in a format another tool reads — and what leaving would cost.

## European sovereignty — proven facts

Built only from facts on the vendor's own pages; a dimension we could not prove is left open, never scored as zero. Headline: not determined.

| Dimension | Finding | Points | Source |
|---|---|---|---|
| Legal entity | Not determined | — | — |
| Hosting location | Not determined | — | — |
| Hosting options | Not determined | — | — |
| Open source | Not determined | — | — |
| Data processing agreement | Not determined | — | — |
| Transfer impact assessment | Not determined | — | — |

## Key facts

Each fact is the vendor's own statement, cited to the source page it was read from ([S*n*] → Sources).

**Hosting**
- Snowflake network whitelist: ThoughtSpot Cloud outbound IP must be whitelisted in Snowflake network policy; contact ThoughtSpot support [S3]

**Integrations**
- Audit logs API admin required: yes [S11]
- Dbt cloud API requirements: dbt Cloud API v2 (2.0.0) [S7]
- Dbt cloud credentials: API key · Account ID · Project ID · Environment ID [S7]
- Dbt data freshness: yes [S8]
- Dbt required permissions: Metadata only · Job Viewer · Semantic Layer [S7]
- Siem near real time: Near real-time SIEM shipping [S11]
- Siem output plugins: HTTP · Splunk · Azure Log Analytics · Datadog [S11]
- Siem push interval seconds: 5 [S11]
- Webhooks: yes [S8]

**Legal**
- Address: 444 Castro Street, Suite 1000, 94041 Mountain View, US [S1]

**Product**
- Account lockout configurable: yes [S11]
- Alert creation from watchlist: yes [S9]
- Alert custom message: yes [S9]
- Alert frequencies: hourly · daily · weekly · monthly [S9]
- Alert group subscribers: yes [S9]
- Alert hourly timing: 30- or 60-minute mark [S9]
- Alert minute interval: yes [S9]
- Alert subscriber access requirements: yes [S9]
- Alert subscribers: yes [S9]
- Alert timezone display: cluster deployment timezone [S9]
- Alert weekend option: yes [S9]
- Attributes in cells: yes [S6]
- Attributes in values unsupported: no [S6]
- Blended axes: Blended axes group measures via a Values chip usable in rows and columns [S6]
- Compact row headers: yes [S6]
- Conditional formatting visualized only: New pivot conditional formatting only references visualized columns [S6]
- Connection type: Snowflake is documented under Connections as a live data connection [S3]
- Dataset calculated fields: Datasets support calculated fields and field descriptions [S8]
- Dataset collections discovery: Datasets can be moved into Collections and are discoverable via browsing or searching across Analyst Studio [S8]
- Dataset scheduling: Datasets can be scheduled to update metrics data on a regular cadence [S8]
- Dataset sharing: rename · schedule · publish to Collection · yes [S8]
- Dbt catalog fields: Column data types [S7]
- Dbt certified warehouses: Amazon Redshift · Databricks · Google BigQuery · Snowflake [S7]
- Dbt connect methods: dbt cloud via API key · zip file (required for dbt core) [S7]
- Dbt connection requirements: dbt Cloud Hostname · Environment ID · Service Token with at least "Semantic Layer Only" permissions [S8]
- Dbt connection sharing: yes · users or groups · edit [S7]
- Dbt edit limitations: yes · no [S7]
- Dbt folder limit: contact ThoughtSpot support · 4 [S7]
- Dbt import summary report: JSON · yes [S7]
- Dbt integration availability: contact ThoughtSpot support · yes [S7]
- Dbt manifest fields: Database name · Schema name · Model/Table name · Table description · Column name · Column description · Table relationships (joins) [S7]
- Dbt measure dependencies limitation: no [S7]
- Dbt metadata tags: yes [S7]
- Dbt metric filters limitation: no [S7]
- Dbt metricflow integration: ThoughtSpot integrates with dbt MetricFlow to bring dbt semantic models, metrics, measures, and calculated fields into ThoughtSpot [S7]
- Dbt no auto refresh: no [S7]
- Dbt no relationship import: one Model per table [S7]
- Dbt replaces tables not models: no · yes [S7]
- Dbt semantic layer integration: Analyst Studio integrates with dbt Semantic Layer; the v1 semantic layer integration is being deprecated [S8]
- Dbt semantic translations platforms: Snowflake · Databricks [S7]
- Dbt sql expression limitation: no [S7]
- Dbt supported metric types: Simple Metrics · Ratio Metrics [S7]
- Dbt supported versions: 1.7 and earlier [S7]
- Dbt sync direction: no · yes [S7]
- Dbt sync updates existing: updates existing objects instead of creating new [S7]
- Dbt zip contents: manifest.json · catalog.json [S7]
- Expansion retained in liveboard: yes [S6]
- Formula total limitations: Subtotals/grand totals can be erroneous with aggregated formula measures; subtotals may be missing when categorizing by a formula [S6]
- Free trial audit events: TRIAL_USER_CREATE · TRIAL_USER_DELETE · TRIAL_USER_END · TRIAL_USER_EXPIRE · TRIAL_USER_EXTEND · USER_INVITED [S11]
- Grouped measures totals: yes [S6]
- Heatmap conditional formatting limitation: no [S6]
- Heatmap mode: yes [S6]
- Horizontal scroll headers: Column header has horizontal scroll bar for long measure names [S6]
- Kpi advanced display: yes [S5]
- Kpi ascending only: no [S5]
- Kpi attributes supported: string · date · boolean · yes [S5]
- Kpi change analysis: SpotIQ · yes [S5]
- Kpi change analysis period: two most recent data points [S5]
- Kpi charts available: yes [S5]
- Kpi comparison points: previous available data point · yes [S5]
- Kpi conditional formatting: no · yes [S5]
- Kpi conditional formatting compare column: yes [S5]
- Kpi custom comparison: yes [S5]
- Kpi display options: Show Date Label · Show Sparkline · Show Comparison · Compare with · Positive change color · Negative change color · Max data points [S5]
- Kpi font size liveboards: XS · S · M · L · XL · no · yes [S5]
- Kpi limitation detailed keyword: no [S5]
- Kpi limitations keywords: growth · versus [S5]
- Kpi monitor alerts: yes [S5]
- Kpi monitor permissions: view access · edit access [S5]
- Kpi multi row topmost: topmost value [S5]
- Kpi save options: save as Answer · add to Liveboard · Monitor alerts [S5]
- Kpi single measure auto: auto KPI chart with topmost value for single measure [S5]
- Kpi single point change analysis beta: Beta · yes [S5]
- Kpi single point enablement: yes [S5]
- Kpi single point limitations: no [S5]
- Kpi sparkline: yes [S5]
- Kpi time buckets: DoD · WoW · MoM · QoQ · YoY [S5]
- Kpi time series aggregation: yes [S5]
- Kpi visualized columns: first search term visualized; reassign via chart configuration [S5]
- Kpi watchlist: Home Page · Liveboard · Saved Answer · yes [S5]
- Liveboard xlsx export: yes [S6]
- Liveboard xlsx export requirements: yes [S6]
- Looker sql connection: Looker SQL connection via Looker's Open SQL interface [S8]
- Looker sql query syntax: Looker SQL queries use backticks for identifiers and AGGREGATE() for LookML measures; measures not allowed in GROUP BY [S8]
- Measure grouping: Measures can be grouped via Values chip to share an axis and positioned in rows/columns [S6]
- Measure sort rows only: rows only [S6]
- Measures in rows: columns · yes [S6]
- Model related audit events: CREATE_MODEL · UPDATE_MODEL · DELETE_MODEL · CREATE_VIEW · UPDATE_VIEWS · DELETE_VIEWS · CREATE_RELATIONSHIP · UPDATE_RELATIONSHIP · DELETE_RELATIONSHIP [S11]
- Monitor alert types: Anomaly alerts · Threshold alerts · Scheduled alerts · Alerts by attribute · Webhooks for Monitor [S9]
- Multi attribute sort: yes [S6]
- New pivot conditional formatting scope: New pivot tables allow conditional formatting based on any other visualized column's values [S6]
- New pivot data limits: up to 100,000 rows per measure · 100,000 rows divided by number of measures [S6]
- New pivot features: faster expand interaction · pagination · custom sort order · column widths · slicing with measures and attributes · measure names and values · tooltips · legends · zebra mode · decluttered header space [S6]
- New pivot function limitations: yes [S6]
- New pivot limitations: New pivot table total size limit is 100,000 divided by number of measures [S6]
- New pivot settings enabled via support: New pivot table data and display limits are enabled via ThoughtSpot support [S6]
- New pivot visual units: 20000 · 15000 [S6]
- Number conditional formatting: cannot set different rules for cells vs column summaries · yes [S6]
- Org audit events: ORG_ACCESS_GRANTED_TO_USER · ORG_CREATION_FAILED · ORG_CREATION_SUCCESSFUL · ORG_DELETION_FAILED · ORG_DELETION_SUCCESSFUL · ORG_SWITCH_FAILED · ORG_SWITCH_SUCCESSFUL [S11]
- Passthrough indexing recommendation: ThoughtSpot recommends turning off indexing for sensitive columns when using passthrough security [S12]
- Passthrough security rls gap: With passthrough security, search suggestions may not respect RLS because index is built on the connection creator's permissions; queries are still blocked [S12]
- Percent of total: Display data as percent of row, column, or grand total [S6]
- Pivot contextual menu: Right-click headings: exclude/include values, drill down, show underlying data, SpotIQ analyze, sort [S6]
- Pivot reordering: Restructure via drag-and-drop in chart configuration or on table headings [S6]
- Pivot row limit: 100000 [S6]
- Pivot sorting: Sort via right-click menus or search bar sort by syntax [S6]
- Pivot summaries: Column and row summaries display optional with configurable position (top or bottom) [S6]
- Pivot table definition: Chart type visualizing data horizontally and vertically in a customizable table with drag-and-drop [S6]
- Pivot table requirements: Requires at least one attribute and one measure in the search [S6]
- Rls custom sort exception: RLS not applied to string values in custom sort order [S12]
- Rls definition: yes · row-level security restricts table row data at group or user level via filter rules associated with groups [S12]
- Rls join definitions: RLS rule definition location (fact referencing fact, fact referencing dimension, or on dimension) impacts whether join definitions are respected [S12]
- Rls scale: yes [S12]
- Rls use cases: hide sensitive data from groups · filter tables to reduce size · single Liveboard displaying different data per accessing group [S12]
- Scheduled alerts available: yes [S9]
- Search suggestions rls: Search typeahead suggestions, Liveboard Explore suggested tokens, and Search Data column info card respect RLS when rule defined on the source table [S12]
- Security audit events: Security audit events for account activities and user actions [S11]
- Security event fields: event ID · description · UTC timestamp · initiating user ID · public IP · event-specific fields [S11]
- Security events fetch methods: SIEM push · Audit Logs API [S11]
- Security events retention days: 30 [S11]
- Semantic layer dataset creation: Reusable Datasets enable end user visual exploration, created via a SQL editor interface [S8]
- Share objects discoverability field: SHARE_OBJECTS event includes discoverability field [S11]
- Siem setup requires support: yes [S11]
- Snowflake auth0: Auth0 authentication · yes [S3]
- Snowflake aws privatelink: AWS PrivateLink · yes [S3]
- Snowflake azure ad oauth: Azure AD OAuth · yes [S3]
- Snowflake connection: Connect to Snowflake in ThoughtSpot Cloud with live queries for Answers and Liveboards [S3]
- Snowflake connection management: Add, edit, remap, delete, deactivate Snowflake connections [S3]
- Snowflake CSV upload: CSV upload to Snowflake connection · yes [S3]
- Snowflake external tables: Query external tables · yes [S3]
- Snowflake gcp private service connect: GCP Private Service Connect · yes [S3]
- Snowflake keypair migration: Key Pair authentication migration from Service Account supported [S3]

**Support**
- Dbt troubleshooting: Troubleshooting documented via Common errors encountered during dbt integration page and error ID table [S7]

29 more facts on the canonical page: https://whats-best.ai/software/business-intelligence/thoughtspot

## Questions

### Is ThoughtSpot European?

Not determined: the vendor’s pages as captured do not say where ThoughtSpot is based.

### Where does ThoughtSpot store data?

Not stated on the vendor’s pages as of 17 Nov 2026.

### Does ThoughtSpot have a free plan?

Not stated on the vendor’s pages as of 17 Nov 2026.

### What are the best alternatives to ThoughtSpot?

As of 19 Nov 2026, the panel rates [Metabase (3.5/5)](https://whats-best.ai/software/business-intelligence/metabase), [Preset (Apache Superset) (3.5/5)](https://whats-best.ai/software/business-intelligence/preset) and [Holistics (3/5)](https://whats-best.ai/software/business-intelligence/holistics) highest among the other 22 Business Intelligence & Dashboards products evaluated. Ratings that look equal are rounded to half stars; the order uses the unrounded rating, then the name. The highest-rated European alternative is [Luzmo](https://whats-best.ai/software/business-intelligence/luzmo) (EU-Made, Belgium). Ratings are the AI panel’s opinion, formed from public evidence: [how scores are made](https://whats-best.ai/methodology#ordering). The full list, with European products first: [ThoughtSpot alternatives](https://whats-best.ai/software/business-intelligence/thoughtspot/alternatives).

## What this page leaves out

- We could not confirm any pricing information on the vendor’s own pages as captured, so this page shows none rather than a statement we cannot stand behind.
- We could not confirm any compliance information on the vendor’s own pages as captured, so this page shows none rather than a statement we cannot stand behind.
- 28 product facts could not be confirmed on the vendor’s page as captured and were left out of this page and of the panel’s material.
- 4 legal facts could not be confirmed on the vendor’s page as captured and were left out of this page and of the panel’s material.
- 1 integrations fact could not be confirmed on the vendor’s page as captured and was left out of this page and of the panel’s material.
- 1 support fact could not be confirmed on the vendor’s page as captured and was left out of this page and of the panel’s material.

## Sources

- [S1] Vendor page: https://www.thoughtspot.com (checked 2026-11-17)
- [S2] Terms of service — found from the homepage: https://www.thoughtspot.com/thoughtspot-website-terms-use (checked 2026-11-17)
- [S3] Data sources, connectors & refresh — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/connections-snowflake.html (checked 2026-11-17)
- [S4] Data sources, connectors & refresh — found from sitemap: https://docs.thoughtspot.com/software/26.9.0.sw/tsload-connector.html (checked 2026-11-17)
- [S5] Dashboards, charts & interactivity — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/chart-kpi.html (checked 2026-11-17)
- [S6] Dashboards, charts & interactivity — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/chart-pivot-table.html (checked 2026-11-17)
- [S7] Self-service analysis & shared metrics — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/dbt-metricflow-integration.html (checked 2026-11-17)
- [S8] Self-service analysis & shared metrics — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/analyst-studio-dbt-semantic-layer.html (checked 2026-11-17)
- [S9] Sharing, scheduled reports & embedding — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/monitor-alert-scheduled.html (checked 2026-11-17)
- [S10] Sharing, scheduled reports & embedding — found from sitemap: https://www.thoughtspot.com/product/embedded (checked 2026-11-17)
- [S11] Access control, administration & portability — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/audit-logs.html (checked 2026-11-17)
- [S12] Access control, administration & portability — found from sitemap: https://docs.thoughtspot.com/cloud/26.11.0.cl/security-rls.html (checked 2026-11-17)

---

Cite as: whats-best.ai, "ThoughtSpot — Business Intelligence & Dashboards", AI panel analysis, as of 2026-11-21. https://whats-best.ai/software/business-intelligence/thoughtspot

Corrections: https://whats-best.ai/correct/1924?target=page
