ThoughtSpot Analyst Studio
Analyst Studio is ThoughtSpot’s code-first ‘creator space’ for data teams — a cloud SQL IDE, Python/R notebooks, schema browsing, profiling and prep. It’s where Mode’s code-first BI now lives, feeding the governed model that powers AI-BI (Spotter). Data-readiness for AI.
Buy through TechBag
Same software. Better outcome — at a lower cost.
How it’s rated
Full scoreboard ↓Quick answer
The ThoughtSpot platform family
This page covers Analyst Studio — the code-first creator space for data teams. The rest of the ThoughtSpot platform:
Quick facts
30-second orientation- Product
- Analyst Studio — code-first space for data teams
- Vendor
- ThoughtSpot (founded 2012 · CEO Ketan Karkhanis)
- Launched
- January 2025 — the creator space for data teams
- Mode is here
- Mode Analytics (acq. 2023) folded into Analyst Studio
- What it does
- SQL IDE + Python/R notebooks + data prep + profiling
- 2026 additions
- Agentic Data Prep + SpotCache (fixed-cost AI caching)
- The role
- Data-readiness for AI — feeds the model that powers Spotter
- India
- Indian-origin founders · huge Bangalore R&D
- Vs
- Mode (standalone), Hex, Databricks notebooks, Sigma, Count
- In India via
- TechBag — scoping, licensing, local support, GST
Understand code-first BI (and where Mode went) before you buy it
Most product pages skip this. We start here — so you buy a capability, not a buzzword.
What is Analyst Studio?
ThoughtSpot’s code-first ‘creator space’ for data teams — a cloud SQL IDE, Python/R notebooks, schema browsing, profiling and prep. It’s where Mode Analytics now lives, and it feeds the governed model that powers AI-BI.
Scattered data-team tools vs one code-first workspace (Analyst Studio) — the honest table
What consolidation actually replaces, dimension by dimension.
| Dimension | Scattered data-team tools | Analyst Studio |
|---|---|---|
| Where data teams work | Scattered scripts & local tools | One code-first cloud workspace |
| SQL | Separate SQL editor | Native cloud SQL IDE |
| Notebooks | Local Jupyter, hard to share | Python/R notebooks, in the workspace |
| Data prep | Ad-hoc, code-only | Prep + Agentic Data Prep (grid) |
| Mode | Standalone Mode product | Folded into Analyst Studio |
| AI cost | Runaway warehouse spend | SpotCache — fixed-cost AI caching |
| The payoff | Analysis in isolation | Feeds the governed model (Spotter) |
| Best fit | (varies) | Code-first data teams on the modern stack |
ThoughtSpot Analyst Studio is a code-first creator space for data teams — SQL IDE, Python/R notebooks, schema browsing, profiling and prep. It’s where Mode’s code-first BI now lives, feeding the governed model that powers AI-BI (Spotter). 2026 adds Agentic Data Prep & SpotCache. Honest: code-first (not business-user), cloud-DW-oriented, premium/quote-priced. Best standalone notebook? Hex. All-in on Databricks? Its notebooks. Grid analytics? Sigma. TechBag scopes it, explains the Mode move & adds GST.
The five pieces of the platform
Vendors love diagrams; buyers need to know what they’re actually operating. Here’s the whole platform, demystified.
Cloud SQL IDE
A native cloud SQL IDE: write, run and iterate on SQL against your cloud data warehouse in the browser, with schema browsing and no local setup.
Python & R Notebooks
Full Python and R notebooks sit alongside SQL for statistics, data science and advanced analysis beyond what SQL alone can do.
Data Prep & Profiling
Visual data profiling and prep tools let you inspect distributions, spot quality issues and shape data into analysis-ready form before it flows downstream.
Mode, Folded In
This is where the acquired MODE ANALYTICS capabilities now live: Mode’s code-first, SQL-and-notebook BI, no longer a standalone brand, folded into Analyst Studio.
Feeds the Semantic Model
Prep and business-logic work done here feeds the governed semantic model behind the AI-BI layer (Spotter), so business users’ AI answers are trustworthy.
A single view over every signal and data store — answers arrive where questions are asked, not pieced from silos.
Twelve capabilities. Explore, prep, analyse.
Analyst Studio is the code-first workspace where data teams prep data & build the model that powers AI — the creator space of the ThoughtSpot portfolio.
Native Cloud SQL IDE
A browser-based SQL IDE to write and run SQL against your cloud data warehouse and iterate fast, with no local setup.
Schema Browsing
Browse tables, columns and relationships in your warehouse within the workspace, so you understand the data before querying.
Visual Data Profiling
Profile data visually — distributions, nulls, cardinality, quality issues — to validate it before you build on it.
Data Prep & Cleaning
Shape, clean and transform data into analysis-ready form, the prep that makes everything downstream reliable.
Agentic Data Prep (2026)
A spreadsheet-style, AI-assisted prep interface to shape data in a familiar grid without heavy coding.
Business-Logic Development
Encode metrics, definitions and transformations once, as the trusted foundation for analysis and the governed model.
Python & R Notebooks
Full Python and R notebooks alongside SQL for statistics, data science and analysis that goes beyond SQL.
Code-First BI (Mode heritage)
The code-first, SQL-and-notebook BI that came from Mode: build analyses and reports in code, not drag-and-drop.
SpotCache — Fixed-Cost AI Caching (2026)
SpotCache gives fixed-cost caching for AI workloads, so heavy, repetitive AI queries don’t blow up warehouse spend.
Live on the Cloud Warehouse
Works live against Snowflake, Databricks or BigQuery, with no extracts, so you always query current data at warehouse scale.
Team Collaboration
Analysts, engineers and scientists share one workspace for SQL, notebooks and prep, instead of scattered local tools.
Data-Readiness for AI (feeds Spotter)
Prep and modelling here feed the governed semantic model behind Spotter, so business users’ AI answers are trustworthy.
Watch Analyst Studio in action
The overview, getting started, and the core workflows.
ThoughtSpot's Analyst Studio — Day in the Life Demo
A day in the life in Analyst Studio.
Product Spotlight: Spotter 3
The AI-BI layer Analyst Studio feeds.
Stop Searching. Start Knowing: Automated Insights with SpotIQ
Automated insights on top of prepped data.
Want a live, India-context walkthrough for your environment?
Book a guided demo →Data is everywhere. Answers, in one place.
Here’s what genuinely sets ThoughtSpot Analyst Studio apart (and where a rival leads).
The code-first workspace for data teams — SQL, notebooks and prep in one place
Technical data teams juggle a SQL editor, local Jupyter notebooks, scripts and a separate profiling tool. Analyst Studio puts a cloud SQL IDE, Python and R notebooks, schema browsing, visual profiling and data prep in one browser workspace, live on the warehouse, feeding the model the business uses.
Mode's code-first BI, now folded into Analyst Studio
Mode, the pioneering code-first SQL-and-notebook BI tool, was acquired by ThoughtSpot in 2023 for roughly $200M and is no longer a standalone brand. Its capabilities now live in Analyst Studio, inside ThoughtSpot and feeding the governed model. Existing Mode users should treat Analyst Studio as the go-forward home.
Data-readiness for AI — the prep that makes AI answers trustworthy
An AI analyst is only as good as the data and model beneath it. Analyst Studio is where analysts clean and profile data and define the business logic and metrics that become the governed semantic model. That model grounds Spotter’s answers, so the data team’s prep makes business users’ AI answers trustworthy.
Modern additions — Agentic Data Prep and SpotCache (fixed-cost AI)
2026 adds two features. Agentic Data Prep gives a spreadsheet-style, AI-assisted grid, so people who don’t write transformation code can prep data in the same governed workflow. SpotCache adds fixed-cost caching for repetitive AI query patterns, so AI on a consumption-priced warehouse has predictable cost.
An India-origin analytics leader — and TechBag adds the local layer
ThoughtSpot was co-founded by Indian-origin engineers Ajeet Singh (also a Nutanix co-founder) and Amit Prakash (ex-Google), with R&D in Bangalore since 2017, Trivandrum and Hyderabad. It fits the Snowflake and Databricks stacks of Indian GCCs. It is premium and quote-priced in USD; TechBag adds scoping and INR/GST.
The honest scope
Analyst Studio is ThoughtSpot’s code-first workspace — SQL IDE, Python/R notebooks, profiling and prep — feeding the model behind Spotter, and now home to Mode. It is for technical teams on a cloud warehouse, and premium-priced. Hex offers a polished standalone notebook; Databricks notebooks suit Databricks users; Sigma is a spreadsheet UI.
The numbers behind the platform
What your ThoughtSpot journey looks like
Scoping (& capabilities)
Which capabilities you need and your cloud warehouse. Mode users get the transition explained; TechBag compares Hex and Sigma.
Connect & set up the workspace
Connect Analyst Studio live to your cloud warehouse and set up the SQL IDE, notebooks, schema browsing and profiling.
Prep & build business logic
Prep and profile data and define business logic and metrics for the governed model, with Agentic Data Prep for non-coders.
Feed AI-BI & control cost
The prepped model powers Spotter for business users; SpotCache keeps AI query costs predictable. TechBag supports you (GST).
The review scoreboard
Modelled on Gartner Peer Insights structure. *Counts and breakdowns are illustrative pending verified review collection.
Quick poll — what’s driving your evaluation?
Talk to an advisor“Analyst Studio gave our data team one home: SQL IDE, Python notebooks and prep in the browser, live on the warehouse.”
“As Mode users, it mattered that Mode’s code-first BI now lives in Analyst Studio, feeding our governed model. TechBag explained it.”
“The prep and business logic we build here feed the governed semantic model that powers Spotter for the business.”
“Agentic Data Prep let more of the team shape data in a grid, and SpotCache made our AI query costs predictable.”
“We trialled Hex, a lovely standalone notebook, but Analyst Studio feeds a governed AI-BI layer. TechBag compared them honestly.”
“It is genuinely for our engineers and scientists, not business users, which is what we wanted for prep. Spotter serves the business.”
“Running live on Snowflake with schema browsing and profiling, we validate data before we build, keeping AI answers trustworthy.”
“ThoughtSpot’s India origin and big Bangalore R&D gave our team confidence. TechBag scoped the capabilities and handled GST.”
Where everyone sits — the grids
Analyst firms bury this view behind paywalls, and review-site grids score satisfaction, not fit for your estate. So here’s TechBag’s synthesis of the Code-first BI & notebook market — tap any vendor to see why it sits where it does.
TechBag Data & Observability Grid
Execution strength vs product vision — the classic market map, minus the paywall.
Code-first space, feeds AI-BI. This page.
Code Depth × AI-BI Connection
The grid nobody publishes — notebook & code depth vs code-first depth & AI-BI connection.
Code-first + feeds governed model.
Positions are TechBag’s illustrative synthesis of public review-platform data and vendor documentation — not a reproduction of any analyst graphic. Verify before relying on it.
Analyst Studio vs the code-first / notebook field
Mode (standalone — now folded in here), Hex, Databricks notebooks, Sigma and Count — honest lanes; the edge is a code-first data-team workspace that FEEDS a governed AI-BI layer. Best standalone notebook? Hex. All-in on Databricks? Its notebooks. Grid analytics? Sigma. We say so.
| Dimension | ThoughtSpot | Mode (standalone) | Hex | Databricks notebooks | Sigma | Count |
|---|---|---|---|---|---|---|
| Position | Code-first space, feeds AI-BI | Legacy — now folded in here | Modern notebook/SQL workspace | Notebooks for Databricks teams | Spreadsheet-style cloud analytics | Collaborative data notebook/canvas |
| SQL IDE + notebooks | SQL IDE + Python/R notebooks | SQL + notebooks (legacy) | SQL + Python notebooks | Notebooks (SQL/Python/R/Scala) | SQL + spreadsheet formulas | SQL + notebook cells |
| Data prep & profiling | Prep + Agentic Data Prep + profiling | Basic (legacy) | In-notebook prep | Spark/DLT prep (technical) | Spreadsheet-style prep | Canvas prep |
| Feeds a governed AI-BI layer | Feeds model → Spotter (Spotter) | No | Standalone (no AI-BI layer) | Genie/AI-BI (Databricks) | Standalone | Standalone |
| For technical data teams | Code-first for analysts/engineers | Code-first (legacy) | Code-first, polished | Very technical (Spark) | Semi-technical (grid) | Code-first canvas |
| Modern-data-stack (live warehouse) | Live on Snowflake/Databricks/BigQuery | Live query (legacy) | Live on warehouses | Native to Databricks | Live on warehouses | Live on warehouses |
| AI-cost control | SpotCache — fixed-cost AI caching | N/A | Warehouse-dependent | Cluster/DBU cost mgmt | Warehouse-dependent | Warehouse-dependent |
| Best fit | Code-first data teams that feed a governed AI-BI layer | Existing Mode users — now migrate to Analyst Studio | Best standalone modern notebook | Teams all-in on Databricks | Spreadsheet-style cloud analytics | Collaborative data canvas |
Which data, analytics & observability approach fits you?
Honest fit signals — because the fastest way to lose your trust is to pretend one product wins every scenario.
Choose ThoughtSpot / Analyst Studio if…
- You want a CODE-FIRST workspace for data teams — SQL IDE, Python/R notebooks, schema browsing, profiling and prep in one place
- You want the prep and modelling work to feed a GOVERNED semantic model that powers a trustworthy AI-BI layer (Spotter) — data-readiness for AI
- You were a Mode user — Mode's code-first BI is now folded into Analyst Studio
- You're on the modern data stack (Snowflake/Databricks/BigQuery) — with TechBag adding scoping, the Mode transition & GST
Mode (standalone) if…
- You knew the standalone Mode — note it's legacy; the go-forward home is Analyst Studio inside ThoughtSpot
Hex if…
- You want the most polished standalone modern notebook/SQL workspace, without a governed AI-BI layer
Databricks notebooks if…
- Your team is all-in on Databricks and you want notebooks native to that platform (Spark, Genie)
Sigma / Count if…
- You want spreadsheet-style cloud analytics (Sigma) or a collaborative data notebook/canvas (Count)
What could this save you?
Drag the sliders (data-team headcount; hour cost as loaded rate). Estimates contrast scattered data-team tools (separate SQL editor, local notebooks, ad-hoc scripts) vs ThoughtSpot Analyst Studio (one code-first workspace — SQL IDE, notebooks, prep, profiling — feeding a governed model) — the wins are less tool-sprawl, faster prep, and data-readiness for AI. NB: premium pricing — TechBag scopes your case. Illustrative.
Loaded cost = salary + overheads per productive hour. Illustrative only — your TechBag quote models your actual environment and modules.
Three ways to consume it
ThoughtSpot is PREMIUM and quote-priced, in USD — no simple public list (Analyst Studio is part of the platform; pricing trends toward consumption/credits, with SpotCache offering fixed-cost caching for AI workloads). Enterprise deployments commonly land well into six figures (third-party estimates cite ~$137K/yr average for the platform; treat as indicative). TechBag scopes the capabilities you need (Analyst Studio + others), explains the Mode transition, and quotes current figures with INR/GST.
ThoughtSpot (premium, by quote)
Best for code-first data teams feeding AI-BI
- Analyst Studio (SQL IDE + Python/R notebooks + prep + profiling)
- Mode’s code-first BI folded in + Agentic Data Prep + SpotCache
- Live on your cloud warehouse (Snowflake/Databricks/BigQuery) — quote-based, USD
+ Platform add-ons
Best for a broader rollout
- Scoped to your estate
- Add-on modules as needed
- Phased, right-sized deployment
+ model help & local support
Best value with TechBag
- The Mode-to-Analyst-Studio transition explained for former Mode users
- Honest Hex / Databricks notebooks / Sigma comparison + semantic-model help
- TechBag adds onboarding, INR/GST invoicing & local support
Buy it for less — TechBag pricing beats list
Whatever the list prices above, TechBag negotiates a significantly better deal — with GST-compliant INR invoicing and local support. Ask us for your discounted quote.
Get an India-ready quote
Tell us your requirements and current tools — we’ll model it against what you spend today.
The 8 questions to ask every vendor
Take this into your next vendor call — including ours.
Want one home for your data team? Analyst Studio is a cloud SQL IDE + Python/R notebooks + schema browsing + profiling + prep.
Were you a Mode user? Mode's code-first BI is now folded into Analyst Studio — TechBag explains the migration.
Want trustworthy AI answers? The prep and modelling here feed the governed model that powers the AI-BI layer (Spotter).
Want prep beyond coders? A spreadsheet-style prep interface (2026) opens data shaping up to more of the team.
Worried about AI query spend? SpotCache provides fixed-cost caching for AI workloads — predictable cost.
On Snowflake/Databricks/BigQuery? Analyst Studio works live on the warehouse — no extracts, current data.
Weighing Hex (polished notebook), Databricks notebooks, or Sigma (grid analytics)? TechBag compares honestly.
ThoughtSpot is India-origin with huge Bangalore R&D — TechBag adds local scoping, onboarding, INR/GST and support.
Questions buyers ask
Ready to give your data team a code-first home — that feeds AI?
Scope ThoughtSpot Analyst Studio (the code-first creator space for data teams — SQL IDE, Python/R notebooks, schema browsing, profiling and prep, where Mode’s code-first BI now lives) — and let a TechBag advisor scope the capabilities, explain the Mode transition, help build the semantic model it feeds (so Spotter’s answers are trusted), compare vs Hex/Databricks/Sigma honestly, and add INR/GST and local support.
Stats, ratings, review counts and pricing are illustrative and sourced from public materials; verify before purchase.