Hex vs ThoughtSpot (2026)

The Hex agent writes and runs SQL and Python against Snowflake, BigQuery, Databricks, Redshift, Postgres and other connected warehouses, and as an MCP client it calls tools on Notion, Linear or any other MCP server the workspace connects (public beta).

The agent works with any data connection or semantic model the user already has access to, and admins can let it search the web and extract content from URLs. Team plans add the REST APIs, OAuth and integrations with Airflow, Dagster and dbt, and Enterprise adds OAuth database connections. Users can also upload CSV files or images for the agent to work with, and an uploaded CSV can be joined with warehouse data.

SourceHex, learn.hex.tech Notebook agent docs and changelog, and hex.tech/pricingread 2026-10-05

AgentSpot agents act inside the tools teams already use, such as Salesforce, Slack, Asana and Jira, for example routing work through Slack and creating Asana tasks, across CRM, HCM and ERP systems.

The connector list runs past 60 systems, including Google Workspace, Microsoft 365, Notion, Snowflake, HubSpot, Zoho, Gong, Stripe, Rippling, Gusto, Zendesk, ServiceNow, GitHub, PagerDuty, Linear, Airtable and Zapier.

On the analytics side, every plan includes prebuilt data connectors, Essentials lists live connections to Snowflake, Databricks and Redshift, and Pro adds MCP connectors that bring business context to Spotter.

SourceThoughtSpot, thoughtspot.com/agentspot and /pricingread 2026-10-05

Work is built as notebooks of SQL, Python and no code cells that the team arranges and the agent creates, edits and runs cell by cell, and a whole notebook runs as one flow across its cells. The Notebook Agent can add Python, SQL, Markdown, pivot, input parameter, single value and chart cells, move cells around and delete them with the dependent cells in view, and lay out the published app in rows, columns and tabs.

Fix with agent takes on multistep repairs across cells, while Quick fix handles small errors such as syntax. A chat agent in Claude, ChatGPT or Cursor can also create a Hex project through the MCP server, add cells and run the whole notebook, with its edits landing in the draft rather than the published app.

SourceHex, learn.hex.tech Notebook agent and MCP server docsread 2026-10-05

In AgentSpot a team describes the work and the platform assembles a team of agents with their tools, steps, logic and handoffs, and the team defines how those agents work together. Each agent is assembled from a plain language description, without code or templates, and carries out multistep actions across the systems the business runs on.

AgentSpot has a free plan with 25 credits a week and a Fleet plan at $1,650 a month with 250 credits a week. Inside the analytics platform, SpotterViz plans a story, generates the answers it needs and builds a complete Liveboard, from structure to layout and styling.

SourceThoughtSpot, thoughtspot.com/agentspot and /product/agents; thoughtspot.com/blog/introducing-agentspotread 2026-10-05

Scheduled runs and alerts on Team and Enterprise run projects without a person starting them, and the agent is also reachable in Slack, through MCP clients, the CLI and the APIs.

On those plans schedules run hourly, daily, weekly, monthly or on a cron expression, and conditional notifications go out only when a set condition is met, while Professional allows one scheduled run per project without Slack notifications or custom schedules.

Tasks, in beta, put the Threads agent on a daily, weekly or monthly schedule and deliver its answer to Slack or email with a link back to the Thread. In Slack, people tag @Hex in a channel or thread or message the app directly.

SourceHex, learn.hex.tech Scheduled runs, Tasks and Hex Agent in Slack docs, and hex.tech/pricingread 2026-10-05

AgentSpot runs workflows on a recurring schedule and on events, so agents act without a person starting each run; Spotter is also reachable embedded in Salesforce, ServiceNow, Slack and mobile. Examples include a weekly pipeline digest sent every Monday and an onboarding run that starts on each new hire's start date. Every analytics plan from Essentials up includes automated KPI monitoring and anomaly alerts, along with mobile apps for iOS and Android.

SourceThoughtSpot, thoughtspot.com/agentspot and /pricingread 2026-10-05

Agents ground answers in the organization's context: they search endorsed semantic models synced from dbt, and Context Studio manages the semantic models, guides and skills they draw on. Guides take two forms, a workspace context file that every conversation reads and a library the agent pulls from by relevance, and a guide can point the agent at specific projects.

Admins and managers edit them together in Context Studio, test questions against a draft before publishing and can roll back to an earlier version, or manage them from the CLI or GitHub Actions, in which case they are read only inside Hex. Semantic model views let a data team rename and regroup dimensions and measures for business users, and the Notebook Agent also reads other projects the user can explore.

SourceHex, learn.hex.tech Guides and Notebook agent docs and changelogread 2026-10-05

Spotter's answers are grounded in verified business definitions in ThoughtSpot's semantic layer, which SpotterModel builds from raw data into governed semantic models. SpotterModel works from natural language rather than hand written SQL, and Spotter can work across structured and unstructured data, with Python and forecasting for deeper analysis. Pro plans list a semantic layer built for agents, and ThoughtSpot ties its answers to a patented search token architecture built for transparency.

SourceThoughtSpot, thoughtspot.com/product/agents and /pricingread 2026-10-05

Threads persist and can be continued later, and notebooks keep version history. Hex describes no memory that the agent keeps from one conversation to the next, and guides in Context Studio are context that people write for the agent. Notebook Agent conversation history lasts 30 days, and starting a new thread clears the context. Each user can also set personal instructions for the agent in a rules file.

SourceHex, learn.hex.tech Notebook agent docs and changelogread 2026-10-05

AgentSpot describes memory that compounds, with each action drawing on past decisions, preferences and domain knowledge, but what is kept, for how long and how it is reviewed or deleted is not stated. The same page says agents learn and adapt from each interaction.

SourceThoughtSpot, thoughtspot.com/agentspotread 2026-10-05

By default the agent runs in Ask for approval mode and pauses before destructive actions such as deleting cells or publishing; a Skip approvals mode exists, the last agent turn can be undone, and security sensitive actions such as OAuth authorization always require approval. In approval mode, each cell the agent changes waits for the user to confirm or undo it.

Admins can mark data connections as sensitive, and a client reaching a sensitive connection through the MCP server needs admin approval first. For the Slack agent, admins choose whether answers drawn from sensitive data arrive as a private reply, as a link only, or not at all.

SourceHex, learn.hex.tech changelog, Notebook agent, MCP server and Hex Agent in Slack docsread 2026-10-05

The data team reviews and approves the semantic models SpotterModel generates before they are put to use, while the agent does the rest of the modeling work. SpotterModel maps relationships, dimensions and measures with a person validating the result. In AgentSpot, fine grained permissions set what each person can see and do, and no approval step before an agent acts is described.

SourceThoughtSpot, thoughtspot.com/product/agents and /agentspotread 2026-10-05

Hex holds a SOC 2 Type II report and lists HIPAA, PCI and GDPR in its trust center, supports SSO through Google, Okta and OIDC, limits actions by user role, and offers audit logs and BYOK on Enterprise. Data at rest, including database credentials, uploaded files and cached query results, is encrypted with AES 256, and traffic uses TLS 1.2 or newer.

Permissions are set across user roles, data access and project access. Production systems at Hex sit behind multifactor authentication, and the company runs regular penetration tests, a private bug bounty program and code scanning. OIDC SSO is listed on the Enterprise plan, and HIPAA coverage is sold there as an add on.

SourceHex, hex.tech/security and /pricingread 2026-10-05

ThoughtSpot holds SOC 1, SOC 2, SOC 3, ISO 27001 and CSA STAR Level 1, and supports SAML and OIDC SSO, role based access and row and column level security. Data is encrypted with TLS in transit and AES 256 at rest, with keys held in a key management system, and multifactor authentication is supported. Login and activity logs are secured and monitored for anomalies.

Row level security and encryption come with every analytics plan from Essentials, while SSO over SAML, OAuth or OIDC, unlimited permission groups and advanced data encryption are Enterprise features. AgentSpot adds single sign on and role based access with strict data isolation.

SourceThoughtSpot, thoughtspot.com/trust/security, /pricing and /agentspotread 2026-10-05

The agent's actions are the notebook cells it writes and runs, visible in the project with their code and outputs, Context Studio shows which model the agent picked and thread level token spend, and Enterprise adds an Observability API. In Context Studio, admins and managers on Team and Enterprise track agent conversation volume and the most active users, and admins can open any conversation to see which context the agent drew on, while managers see totals only. Scheduled run history is kept for 90 days.

SourceHex, learn.hex.tech changelog and Scheduled runs docs, and hex.tech/pricingread 2026-10-05

AgentSpot logs every request, tool call and model interaction, and Spotter reasons through each step and shows it, so both the answer and the actions behind it can be traced. Across the platform, user login and activity logs are kept, secured and monitored for anomalies.

SourceThoughtSpot, thoughtspot.com/agentspot and /trust/securityread 2026-10-05

Hex can be deployed single tenant in a geographic region of the customer's choosing among those AWS supports, sold as an Enterprise add on, alongside the multi tenant cloud on AWS. Custom deployments run on their own address, such as eu.hex.tech or a company subdomain, which takes the place of app.hex.tech for tools like the MCP server. Team and Enterprise workspaces can add larger compute profiles billed by the minute, from 16 GB of memory up to 128 GB and A10G or L4 GPUs, while the free Community plan runs on small compute and Professional on medium.

SourceHex, hex.tech/security and /pricing, and learn.hex.tech MCP server docsread 2026-10-05

Customers choose the data residency region for their ThoughtSpot environment based on compliance needs, with options across AWS, GCP and Azure. Embedded Enterprise customers can add VPN and VPC deployment options. Enterprise editions of both the analytics and embedded platforms support custom domains and multi tenant setups organized by customer organization.

SourceThoughtSpot, thoughtspot.com/trust/security and /pricingread 2026-10-05

A public gallery of more than 40 ready made analysis templates across 13 categories, such as customer segmentation, anomaly detection, A/B testing and a text to SQL chatbot, ships alongside the built in Notebook Agent and Threads.

The categories range from clustering and feature selection to KPI dashboards, natural language processing, time series and Snowpark, with examples such as market basket analysis, collaborative filtering and geospatial analysis.

Teams can also package reusable cells as shared components and group work into shared collections, with three of each on the free plan and unlimited collections on Team.

SourceHex, hex.tech/templates and /pricingread 2026-10-05

ThoughtSpot ships four named, ready made agents: Spotter for analytical questions, SpotterModel for semantic modeling, SpotterViz for dashboards and SpotterCode for coding in IDEs. SpotterCode turns a short prompt into the code patterns, components and embed logic a developer needs.

On the analytics plans, Pro includes all four agents with 25 Spotter queries a month per user, and Enterprise makes them unlimited, while the free Developer plan for embedding includes the same core agents. AgentSpot publishes example agents such as New-Hire Onboarding Runner, Hiring Pipeline Digest and Interview Feedback Chaser.

SourceThoughtSpot, thoughtspot.com/product/agents, /pricing and /agentspotread 2026-10-05

Users pick a model in the agent's model picker or leave it on Auto, which selects the model suited to the task, across Anthropic and OpenAI models served directly or through AWS Bedrock and Google; admins can bring their own provider keys so inference runs through their own accounts. Effort levels can be set beside the model choice.

Bring your own key is an Enterprise feature that covers Anthropic, OpenAI, AWS Bedrock and Google Gemini Enterprise Agent Platform, and admins can make it mandatory. By default the providers run under zero data retention and do not train on customer data, and admins decide whether to allow models that need temporary retention for safety monitoring. Agent use draws on monthly credits per seat, standard on Professional, extended on Team and premium on Enterprise, and the free plan includes an agent trial.

SourceHex, learn.hex.tech AI data privacy and Notebook agent docs, and hex.tech/pricingread 2026-10-05

Spotter works with GPT series models, Google Gemini, Snowflake Cortex and Claude, and the Spotter deployment docs include a Connect to your Large Language Model page for a customer's own LLM. Flexible LLM selection is listed as an Enterprise analytics feature. ThoughtSpot does not meter or charge for LLM tokens, so model use is covered by the subscription, and Pro includes unlimited tokens under platform governance.

SourceThoughtSpot, thoughtspot.com/product/agents and /pricingread 2026-10-05

An MCP server at app.hex.tech/mcp with OAuth exposes named tools to search projects, create and continue Threads and create, edit, delete and run notebook cells, alongside a public REST API and a CLI. The server runs on Team and Enterprise, where tools that search projects and run Threads need the Explorer role and tools that change or run cells need Editor or above. Claude Desktop, Claude Code, Cursor, ChatGPT, Codex, Glean and Figma are named as clients. The REST APIs come with Team, and Enterprise adds an Observability API.

SourceHex, learn.hex.tech MCP server docs and hex.tech/pricingread 2026-10-05

The documented Spotter MCP Server at agent.thoughtspot.app, with OAuth or bearer token authentication and date based versions, lets Claude, ChatGPT, Gemini or custom clients run natural language queries, create Liveboards and visualizations and search content; it is an add on for Enterprise and Embedded plans, beside ThoughtSpot's REST API and embed SDK.

OAuth suits ready made clients and bearer tokens suit custom applications. The Spotter 3 version of the server adds advanced analytics, reasoning, forecasting and automatic selection of the data source. The free Developer plan gives up to 10 users a year of the REST embed API, the Visual Embed SDK and custom styles, themes and actions.

SourceThoughtSpot, developers.thoughtspot.com MCP integration docs and thoughtspot.com/pricingread 2026-10-05

Teams turn the questions they test repeatedly into versioned eval suites, publish them from the CLI, schedule them to run and track agent performance over time in Context Studio, catching regressions when guides or semantic models change. Publishing and scheduling a suite takes the Manager or Admin role. Guide changes can be previewed and tested against specific questions before they go live, and each published version stays in a history that can be compared and rolled back.

SourceHex, learn.hex.tech changelog and Guides docsread 2026-10-05

Spotter checks its own work and refines the result at run time; no test set, accuracy scoring or regression check for agents is described. Semantic models from SpotterModel are validated by people before they go into use.

SourceThoughtSpot, thoughtspot.com/product/agentsread 2026-10-05

Hex does not describe the agent operating a browser or desktop; it works through code, notebook tools and MCP. When an admin turns it on, the agent can also search the web and pull content from a URL.

SourceHex, learn.hex.tech Notebook agent docs; hex.techread 2026-10-05

No browser or desktop operation by Spotter or AgentSpot agents is described; they act through data connections and integrations. Reach into tools such as Figma, Miro, Canva and Zoom comes through the AgentSpot integration list.

SourceThoughtSpot, thoughtspot.com/agentspotread 2026-10-05