Orion vs Hex

Hex is the workspace your team builds analysis in. Orion is the analyst that delivers the answer.

Hex is a data notebook and app environment where data teams build analysis in SQL, Python, and no-code cells. Orion connects read-only across the warehouses you already run and reuses the semantic layer you already trust, like LookML or dbt. It investigates why your metrics moved and delivers the answer to where you already work. Nothing to build.

TL;DR

The analyst, not the workbench

Orion investigates and hands you the answer. Hex is a notebook and app environment your team builds the analysis in.

It finds what you didn't ask

Orion auto-detects the changes no one queued up. Hex runs the recurring questions your team authors and schedules.

The why, written up and delivered

Orion investigates and delivers a written explanation of why your metric moved. Hex's agents answer what your team asks. In Hex, nothing chases the why nobody asked about.

What is the difference between Orion and Hex?

Hex is built for the data team. Orion is built for the whole organization.

Orion

Orion connects read-only to the warehouse you already run and reuses the semantic layer you already trust, like LookML or dbt. Your data team and business users share one governed place to get answers. Business users ask Orion in its chat or in Slack and get the answer on the spot, instead of waiting on the data team’s backlog. Orion watches your metrics and investigates the movement. It delivers the written answer to Slack or email before anyone files a request. Teams work with it in one shared conversation, everyone at their own access level. It sits on top of your stack, with nothing to build and no notebook to maintain. And if you build software yourself, you can embed Orion in your own product as a white-label analyst for your customers.

Hex

Hex is a strong collaborative workspace for data teams. It offers SQL, Python, and no-code cells with reactive execution, published as apps. It adds AI agents that help authors build, and a semantic layer that can sync from dbt and Cube. That power is real. But it is an environment your team builds analysis in, and editors review and confirm its agent-suggested changes cell by cell.

How do Orion and Hex compare feature by feature?

Orion is best for

Business users who can’t wait on the notebook queue

Hex is best for

A powerful SQL, Python, and app workspace for data teams

OrionHex
Finds the unknown unknownsAuto-detects significant changes no one asked aboutRuns the recurring questions you author and schedule
Everyone in one live conversationEveryone posts into one thread and watches the same answer stream, each at their own access level. The Room stays the single record and cannot be forked into private copiesOnly a Thread's creator can prompt it. Teammates can watch it stream or edit the notebook behind it
LookML ingestionReads your LookML where it lives and converts it into governed metric definitionsNo LookML sync in its current docs. Semantic Model Sync imports from dbt MetricFlow, Cube, and Snowflake Semantic Views (beta)
Context from your existing docsA cited Knowledge Base synced from GitHub, Confluence, or NotionContext Studio curates guides, endorsements, and models inside Hex, managed by admins and managers
Analyst, not a workspaceInvestigates and delivers the answer, with nothing to buildA notebook and app workspace your team builds the analysis in
Built for business usersA plain-language answer delivered to Slack or emailThreads answer their owner's prompts. The conversation is read-only when shared
Hands-on notebook and app authoringGenerates dashboards, reports, and decks from a request. Not an authoring environmentA full authoring environment: notebooks, apps, reactive execution, SQL and Python side by side

Do you need a workbench or an analyst?

Hex gives your data team a powerful place to build. But someone still has to decide what to look at, write the notebook, check it, and turn it into something a stakeholder can act on. The work still lands on the analysts you already have.

Orion does that work. It watches your metrics, investigates why they moved across the warehouses you connect, writes the answer, and delivers it to Slack or email. The question gets answered without a project and without a person in the loop.

When should you choose Hex instead?

The Hex vs Orion decision comes down to who is doing the analysis: your data team, or Orion.

Choose Hex if

  • Your data team wants a powerful workspace for bespoke SQL and Python analysis, published as notebooks and apps.
  • Your users are technical enough to audit the SQL and code the AI agents suggest.
  • You want notebooks, apps, and AI authoring in one workspace your analysts control.

Choose Orion if

  • Business users need investigated answers without notebook skills or an analyst in the loop.
  • You want metric changes detected, investigated, and delivered to Slack or email, including the ones nobody scheduled.
  • You want your LookML and dbt read in place, with no copy inside a second system and no sync to maintain.

Orion vs Hex: what do buyers ask most?

Orion answers the recurring 'why did this move' questions from the business directly. They no longer land on your data team as new Hex projects. Hex is built for your data team. Orion is built for the business users who depend on them. Hex is where analysts build analysis: SQL, Python, and no-code cells stitched into notebooks and apps, with AI agents that help authors write and edit. Orion sits on top of the warehouses you already run and watches your metrics. It investigates why they moved and delivers the written answer to Slack or email before anyone opens a notebook.

No. Hex is an authoring environment. The Notebook agent needs editor permissions, and every change it suggests is confirmed or undone cell by cell. The core artifact is a notebook or app a person builds and maintains. With Orion, your team builds the context rather than each analysis: the semantic layer it reads and a cited Knowledge Base the whole org reuses. You ask in plain language, or you ask nothing at all. Orion builds the analysis from that shared context, writes what it found and why, and delivers it. The output is an answer, not a notebook you then have to read, verify, and turn into something a stakeholder understands. One is a workbench for analysts. The other is the analyst. Every analysis Orion runs is still captured as a full record of the instructions, the logic, and the code. Your team can audit exactly how the answer was produced. The difference is nobody had to build it.

Hex runs the recurring questions your team authors. Orion also decides what is worth investigating. Hex Agent Tasks schedule a question and deliver the result to Slack or email, which is genuinely useful. Hex can also flag when an author-defined condition is met. The key word is author-defined: you write the question and the condition in advance. Orion also runs scheduled Workflows, but it adds the step Hex leaves to you: it decides what is worth investigating. It auto-detects the significant changes you did not think to schedule, runs the root-cause analysis, and delivers the write-up. So Hex answers the questions you remembered to schedule. Orion also catches the ones you did not, which is where the problems a stretched team misses actually live.

Both can use dbt, with a real difference in how, and Orion adds LookML. Hex has its own semantic models. A beta Semantic Model Sync imports governed measures and dimensions from dbt MetricFlow, Cube, and Snowflake Semantic Views, pushed from GitHub. Its separate dbt metadata integration requires dbt Cloud. Either way, the import creates a copy inside Hex that you then keep in step. Orion instead reads the LookML and dbt you already trust in place, across both dbt Cloud and dbt Core. That is the governed logic behind every answer. A cited Knowledge Base adds the rest. The model is not copied into a second system, and there is no sync to maintain.

Yes, that is the point of it. A business user asks Orion in plain language, in Slack or its web app, and gets a written answer grounded in your governed metrics. Orion also delivers the finding proactively, without anyone asking. Hex serves this too, through Threads, its conversational surface for non-technical users. The difference is what happens around the ask. A Thread takes prompts from its owner only, and its conversation is read-only when shared. The Notebook agent needs editor permissions and per-cell review of its changes. In Hex, nothing investigates what no one asked. Orion answers the asker directly, in a conversation the whole team can join. It also delivers findings before anyone asks at all.

A Room is one conversation your whole team shares with Orion. Questions from the analyst and the finance lead land in the same thread with attribution. Everyone acts at their own access level. Someone with view-only rights can follow the investigation without running anything. Co-editing a notebook shares the workspace. A Room shares the investigation, one conversation your data team and your business have together, with Orion in it.

Orion connects read-only, through dedicated least-privilege service accounts you provision per source, with optional per-user OAuth on BigQuery. Orion only ever issues read queries, so it cannot write to or change your warehouse. Credentials are encrypted at rest. Two independent layers of roles, tenant and group, scope who sees which projects, data sources, and Knowledge Base pages.

Yes. Embedded Orion is a white-label analyst for your customers, presented under your brand inside your product. Each customer account is isolated: they see only their own data, business context, and permissions, and nothing passes between accounts. Your customers sign in to your product, and Orion inherits who they are and what they can see. There is no second login. You integrate once. Every new account is provisioned with its own branding, data connections, and access controls, so the second customer costs a fraction of the first. If your team ships a product and customers keep asking for reporting, this gives each of them an analyst. The asks stop landing as notebooks on your data team's queue.

Yes, and it is a natural split. Orion connects read-only to the same warehouses Hex sits on, so the two coexist without conflict. Teams keep Hex as the workbench where analysts do deep, exploratory, and bespoke analysis. They add Orion as the always-on analyst. Orion watches metrics across the whole stack, investigates what changed, and delivers the answer to Slack or email. Hex handles the analysis your team chooses to build. Orion handles the monitoring and the first-pass investigation so those requests never pile up in the first place.

See what your team looks like with an AI Analyst.