[go: up one dir, main page]

Skip to main content
Latest release:

We’ve shipped a lot of big features lately: the Notebook Agent, Threads, the Modeling Workbench, Explore capabilities, and more. This week’s updates are all about enhancing these agentic workflows in Hex, and doubling down on the semantic context and curation tools needed to make AI accurate and useful in your analysis.

🧰 Fix with agent

Debugging code and SQL is tedious, especially when you’re working with a new, unfamiliar dataset. The Notebook Agent can now help!

From an errored Python or SQL cell, you can now Fix with agent. Instead of being limited to looking at one cell and only editing the contents in that cell, the Notebook Agent has full project context and can view/edit upstream cells and compiled SQL.

“Quick fix” is still great for simple syntax errors that are constrained to a single cell, but “Fix with agent” can handle more complex errors that may require changes across multiple cells. You might even find that its explanations help level up your SQL and Python skills!

🤖 Notebook Agent improvements

We’ve been very busy making our Notebook Agent smarter, faster, and more efficient in Hex. Here’s everything we’ve shipped lately:

  • Powered by Claude Sonnet 4.5: The Notebook Agent and Threads are now running on Anthropic's latest model, with significant improvements in speed, capability, and complex task handling for analytics tasks.
  • Using Hex docs: The Notebook Agent and Modeling Agent can now leverage all the technical documentation on our Learn site in its answers, and point you to relevant tutorials and templates. The next time you have a question about Hex’s features, just ask the agent!
  • Implemented Notebook DAG context awareness, so the agent can make more intelligent, dependency-aware decisions about editing
  • Better at handling long-running cells that do heavy queries and analysis
  • More careful about editing vs. creating new cells for a tidier notebook
  • Better at telling you if it doesn’t have a tool to fulfill a request — like input cells, moving cells or deleting cells. (But good news! These are all tools that are coming 🔜)
  • Radically improved ability to write and edit jinja
  • Agent can now run for twice as long without checking in, and is also much more reliable about stopping early and not wasting time
  • Better at recognizing when a user has a quick question vs. a vague problem that needs alignment, in which case it’s better at checking in to coordinate on a plan rather than just diving headlong into doing things
  • Prefers chained SQL to write clean, easier to read SQL
  • Improved usage of Hex charts for nicer interactive visualizations
  • Generally improved response tone to be more concise, higher signal and less fluffy
  • Reduced creation of markdown or Python summary cells, unless explicitly requested
  • Better understanding of components and sections, and correctly placing cells in the notebook

The agent should feel much more intelligent with all these improvements! We’d love to continue to hear your feedback on all this — just drop us a note.

🧵 Threads improvements

Earlier this month, we launched Threads — a conversational interface for everyone to answer questions with data — and the feedback has been awesome to see!

User feedback on Threads

Since then, we’ve made some improvements to make the Threads experience even more delightful:

  • Readiness indicator in browser tabs: Let Threads work in the background while you grab a coffee or respond to an email. When the agent is finished thinking, you’ll see an indicator in the title of your browser tab, so you can jump back in when results are ready.
  • Duplicating threads: Pick up where your coworker’s conversation left off by making a copy of a thread that has been shared with you. The prompt history and previous results will remain upstream for you to reference.
  • @-mention data sources: When you want the Threads agent to use a particular semantic model or warehouse table to answer your question, you can specify a data source with an @ in your prompt.

Please keep the feedback coming, and let us know what you’d like to see next!

🧱 Databricks Metric Views integration

Last year, we introduced Semantic Sync in Hex, enabling teams to turn on trusted self-serve via pre-existing semantic models.

We’ve now added support for Databricks Unity Catalog Metric Views — in addition to syncing with dbt MetricFlow, Cube, and Snowflake Semantic Views. You can now:

  • Browse metric views directly from your Databricks connection in Hex.
  • Query with SQL in the notebook, without redefining metrics.
  • Build data apps that are backed by governed metrics, ensuring consistency from exploring to publishing.

Whether you choose to sync external models or build them natively in Hex’s modeling workbench, these trusted measures, dimensions, and business logic allow the Notebook Agent and Threads to generate more consistent, accurate results.

Read more in our announcement of Hex’s Databricks Metric Views integration.

🔝 Top N and more Explore improvements

Explore continues to grow even more powerful and feature-rich as we add more capabilities for digging into data and building visualizations. The latest addition to Explore’s toolkit is Top N, which helps you answer questions like “Who are our top 10 revenue-generating customers?” without requiring a line of code.

Top N allows you to specify the top (or bottom!) n values for a dimension in a chart or pivot, and choose whether the “other” values are bucketed in the viz.

This is only one of many improvements to Explore over the last six months, so we compiled a round-up of what’s new in Explore (e.g., totals in pivots, aggregate calcs, drilling, and more)!

🧭 New navigation sidebar

With how much the Hex platform has changed and grown over the last year, it was time to refresh our sidebar for consistent, intuitive navigation!

Lean on the nav sidebar as your go-to hub for creating and engaging with assets:

  • Start a new project or thread
  • Jump back into recent work, and find favorites
  • Search your workspace
  • Respond to notifications (all in one place!)
  • Access Settings or Support

It's available from any page in Hex, so folks who are new to your workspace will have an easier time finding their way around. (And our new homepage is a great jumping-off point with a big ol’ prompt bar for asking the agent a question!)

Other improvements

  • Subtotals and sort by values in pivots: In addition to totals, it’s now possible to add subtotals to pivots that have multiple rows or columns. You can now sort by aggregated values in pivot tables.
  • SSH tunneling for Databricks: Our Databricks data connector now supports SSH tunneling for secure connections to databases behind firewalls or in private networks.
  • Custom data retention periods: Admins can now tailor data retention timelines to meet stricter compliance requirements and internal policies. This custom data retention is available for cell outputs and cached warehouse data of 7, 14, 30, 60, or 90 days.
  • Version history in Modeling Workbench: Now you can see a history of changes made to a semantic model and who made those changes. This includes checkpoints created before the Modeling Agent makes a change.
  • Project filters can reference semantic model columns: Project filters are now hooked up to semantic models, so you can build a fully no-code, interactive app based on modeled data.
  • Support for semi-additive measures: Hex's semantic modeling now supports measures on snapshot tables. These semi-additive measures allow you to control which dimensions measures can be aggregated over. They automatically subselect the correct rows, such as only using the latest month of data.
  • Manager role can edit semantic projects: After an Admin creates a semantic project, Managers can now edit them — broadening the pool of folks who can work on semantic models without giving out full Admin access.

🧵 Fall Launch: Threads & more

Introducing Threads — a conversational interface for analytics, made for everyone who wants to answer questions with data. It’s integrated with your team’s existing data workflows, and has access to powerful tools anchored in trusted context.

Today is our biggest release ever, and by far the coolest stuff we’ve built — including new semantic modeling features, Notebook Agent improvements, better no-code viz in Explore, and more!

The highlight? Threads helps you unlock self-serve that actually works:

  • ❓ Ask questions in natural language
  • ⚓ Ground answers in context curated by the data team
  • 💡 Get deeper insights from Hex’s advanced, built-in tools
  • 🛡️ Keep the data team in control of auditing and curation

Threads is available to Explorers+ in public beta on Team and Enterprise plans. Extended AI usage limits are included for free during the early access period.

Ready to dive in? Check out our Threads quickstart guide.

Read our full announcement to learn more.

🤖 The Notebook Agent

Introducing the Notebook Agent — bringing advanced agentic capabilities directly to where data teams are already working. Ask a question, get to a first draft in minutes, and iterate with precision.

The agent can help you do things like:

  • 🗺️ Plan and refine where you want to take your analysis
  • 🔍 Search your data to find the right table
  • ⛓️ Create and chain cells using SQL and Python
  • 📊 Visualize your data with native pivot and chart cells
  • 💡 Summarize and synthesize your findings in Markdown cells

The Notebook Agent is available to Editors+ in public beta on all paid plans. Extended usage limits are included for free during the early access period.

Ready to dive in? Check out our Notebook Agent docs and best practices guide!

Read our full announcement to learn more.

Looking ahead at our roadmap in the coming months, we’re more excited than ever about the future of data — one where data teams are at the center, doing their best work, and enabling the rest of the organization with access to trusted answers.

This week’s updates lay the groundwork, starting with native Semantic Authoring in Hex!

✍️ Semantic Authoring Beta

Last year, we launched Semantic Sync to enable self-serve via pre-existing semantic models. Today we’re taking the next step, bringing speed and trust together in one platform with native Semantic Authoring in Hex.

Now in public beta, the new Modeling Workbench gives Admins on Team and Enterprise plans the ability to curate the ground truth of your business — right where your team is already working.

These models become governed context that flows right into your workflows: consumed in Explore cells, and referenced by Ask Magic and Magic in Explore.

Quote from Uken Games

Read our full announcement to learn more about Hex’s first-class, AI-powered semantic authoring.

➕ Pivot totals and pivot cell glow-up

Pivots got a makeover! Create a new pivot cell in your project to see the sleek redesign, and take advantage of powerful features like:

  • Infinite scroll for a smoother viewing experience
  • The option to transpose values as rows
  • The ability to drill into aggregated values and view row-level data
  • And (🥁 drumroll...) row and column totals!

A key part of exploring data is aggregation — questions like, “What’s the total revenue across this whole data table?” and “What’s the average lifetime value?”

With new pivot cells, totals are displayed by default. No need for more code or an extra cell to arrive at these insights.

Existing pivot cells will still run just fine, but will sport a "Legacy" tag in the notebook. Hover over "Legacy" to duplicate the cell into the new UX.

🧮 Cross-model calcs

In the new Modeling Workbench, you can reference fields across any model or table when writing calcs. That means you can pull a dimension from one model into a calc in another (same goes for measures), as long as there's a join path between them.

Cross-model calcs

Semantic Sync also supports cross-model calcs pulled in from dbt MetricFlow, Cube, or Snowflake Semantic Views.

📋 Audit logging for AI

Curious about AI usage within your Hex workspace? Admins on the Enterprise plan can now see these new events captured in audit logs for security and compliance:

We’re all ears if there are other events you’d like to monitor.

Other improvements

  • Simultaneous total and subtotal labels in stacked charts: You can now display both the color/group label and the total label for stacked bar, column, and area charts — at the same time!
  • New default for project sharing: We updated the default credential sharing setting to Off. That means project-level credential sharing is now opt-in, and Editors should check their preferred published app run settings when publishing new projects. No changes have been made to existing projects or your connection-level OAuth settings — those will continue to work as expected.
  • Notification for downgraded access: Users missing workspace assets (e.g. data connections, secrets) will now see a banner and alert in the notebook flagging their downgraded project access. The updated UI makes it easy to understand what's missing, so they can loop in an Admin and get unblocked.
  • Jump to corresponding cell in the Graph: If you have the Graph view open, clicking on a cell in the notebook will take you to that same cell in the DAG. Got 100 cells in the notebook? (Yikes. 🫠) At least now they’re easier to find in the Graph!
  • Cleaner PDF exports: We tightened up the layout to eliminate extra white space, so exported PDFs look crisper and more polished for those executive eyes. 👀
  • Bulk remove elements in rows: We fixed an issue where bulk removing elements didn’t always work. Now in the App Builder, you can remove multiple elements from the same grid row all at once. Fewer formatting clicks = more time for cool stuff.

This week’s release is all about helping your team scale confidently in Hex. We’ve added new features to make Hex more intuitive and accessible for everyone in your org, and quality-of-life improvements to make it easier to govern, find, and use trusted data across your workspace.

👥 REST and Observability APIs for Admins

We recently announced new APIs for managing Hex workspaces at scale! Admins on Team and Enterprise plans can now use API endpoints to:

  • Automate user role and group management
  • Enforce consistent access policies across teams
  • Plug Hex into your internal IT or data platform tooling
REST and Observability APIs for Admins

Plus, see which tables are queried across projects to better understand data access with a new Observability API now available on the Enterprise plan.

Read more about how you can get some time back by programmatically managing your workspace.

❓ Magic edits in Explore

Now in beta, Magic in Explore helps you iterate faster by editing explorations based on natural language prompts.

Ask Magic will only generate explorations based on endorsed data, for higher confidence in every output. This means you (the mighty steward of data 👑) can optimize Magic’s results by curating the universe your stakeholders explore.

If you’re excited about powering AI with semantic context, we’re starting to roll out early access to native semantic authoring in Hex. Drop us a note at [email protected] to join the alpha waitlist.

We rolled out a new recommended tab in the data browser that spotlights endorsed tables and models, making it easier to find trusted data — no guesswork required.

Admins can curate the data browser using endorsed statuses, so folks outside the data team can find their way with confidence.

Recommended tab in the data browser

The new experience folds in recently used and favorites to keep things streamlined. And now, you can filter tables and models by status or category to zero in on exactly what you need.

🔽 View underlying data in Explore

Want to see the customer seats that make up ARR without creating a new cell or switching views? You can now select portions of your Explore charts and pivots to quickly see the underlying data.

You can also expand or collapse individual aggregate rows to get a deeper look at what makes up an aggregate. This makes it easier to inspect row-level data, all within the table in your exploration.

Other improvements

  • Titles in URLs: Hex URLs got a little nicer! URLs now contain the title of the project in the URL and have a compressed Hex ID to make links slightly shorter. Don’t worry, you can still grab your project’s ID in several ways.
  • Richer audit logs: Admins can now monitor CSV exports and PDF downloads through detailed audit log entries, supporting data governance and compliance requirements.
  • Chart sorting improvements: Full color and facet sorting in charts are here! You can sort categorical "color by" by y-axis for all chart types and sort facets by y-axis and custom.
  • Security & Privacy contacts for your workspace: Admins can now set Security & Privacy contacts in workspace settings to keep the right folks in the loop. These contacts will be notified in the rare event of a security issue (heaven forbid) or if we make updates to our subprocessors.

This week, we’ve got new AI and governance features across the platform, plus highly-requested functionality that makes it easier to slice and present your data.

💬 AI chat 🤝 notebook

We're releasing a new element in the notebook view — an agentic sidebar. Now, it's easier than ever to ask a quick syntax question, brainstorm how to get started on an analysis, or find the data you need.

Today, this is an integrated chat with context on your data and your project, but we have a lot more coming.

Next up: generating and editing cells, smarter integrated context, and continued SQL quality improvements.

If you'd like to try out the bleeding edge and help shape where this feature goes next, you can opt into our alpha version to get the latest updates.

Notebook chat opt-in

📓 Faster, smarter AI edits in notebook cells

We gave the editing experience a glow-up in SQL and Python cells — making it faster, cleaner, and more intuitive.

You can now review AI edits more easily by running a cell before accepting changes. If the output is close but not quite right, you can now tweak the suggested changes directly in the diff view.

We also seriously leveled up response quality, with smarter handling for different warehouse dialects, Jinja syntax, and big ol’ blocks of code.

🔮 Rules files: context for your AI prompts

If you’re using Claude Projects or Cursor rules, you already know how passing some high-level context to your AI agent can influence the response you get.

Now, in Magic admin settings, Hex admins can edit a markdown file which gets passed directly as part of the system prompt for all SQL and Explore cell generations. This is great for bringing in business context that you want Hex’s AI to always know about.

Rules files for AI prompts

📊 Chart style copy & paste

You can now copy and paste styles from one chart to another in Hex — even between projects. It’s the fastest way to keep things looking sharp without reapplying your formatting to cell after cell after cell.

Only the styles that make sense will be carried over, while your chart’s underlying data remains unchanged.

General styles (like font size or legend position) are always copied, while data-dependent styles only transfer if the data lines up — same column name, aggregation, and time unit.

🔐 Snowflake OAuth permissions for schemas

On the Enterprise plan, Hex can now enforce OAuth permissions from Snowflake in the data browser, tightening access controls and reducing accidental data exposure.

Notebook chat opt-in

With this feature, users will only see schema objects they’re actually permissioned to view — including in data browser search and notebook cell typeahead.

Admins can enable this by selecting the new option to apply OAuth permissions to schema data on their Snowflake connection.

To support this, we’re also rolling out mandatory service accounts for OAuth connections, which you can read more about here.

🔽 Filter on aggregates

You can now filter on aggregations directly in Explore charts and pivots — no code required. It’s a faster, easier way to slice your data and hone in on what matters, without breaking your flow.

Under the hood, this manifests as a HAVING clause in the auto-generated SQL, limiting results after they’ve been grouped and aggregated.

Other improvements

  • IBM Db2 data connection: We added a new data connection with IBM Db2 to our growing list of data source integrations.
  • Redesigned filter layout in Explore: Now when you add filters to an exploration or Explore cell, they are displayed nicely across the top of the chart or pivot — making them easier to skim and edit.
  • View underlying data from pivots in published apps: Users with “Can explore” access (or higher) can now click on a pivot value in a published app to dig into the underlying row-level data behind the aggregate. This works when the pivot was built in an Explore cell.