Changelog

🤝 Semantic Model Sync​

Today, we're launching the public beta of Semantic Model Sync to enrich self-serve analytics in Hex with trusted metrics and business logic from dbt MetricFlow, Cube, and LookML (in private beta).

Now, you can empower stakeholders with governed measures, dimensions, and joins for consistent self-serve results in Explore — without compromising the flexibility of ad-hoc analysis or getting locked into a proprietary spec.

Read our full announcement to learn more about how you can import modeled data from your semantic layer into Hex.

This batch of features falls into the category we like to call “pixel-light, impact-heavy”: chart reference lines, a fresh new outline, dropdown display labels… and they’ve just been delivered into your Hex notebooks with laser precision. Hope you enjoy!

📊 Add reference lines to charts​

You can now add vertical and horizontal reference lines to x- and y-axes in charts to indicate targets, thresholds, or important points in time. Want to add a super thick, greenish-brown line with a label at a 90-degree angle in the bottom-right corner? You’re free to style as you please (but we can’t save you from the critiques of that one stakeholder who’s really into color theory).

📔 Redesigned notebook outline​

In November, we released collapsible sections, which make it easier to organize your most complex projects — thanks to all of you who wrote in with some love!

We got hooked on the fan-mail dopamine hit and kept going by building an all-new “compact” outline with a mini overview and condensed summary for easier navigation and search within your notebook:

We've been using this internally for a few weeks now, and it’s changed the game — making it easier to navigate and work with big, gnarly projects. We also made some improvements to sections, including the ability to drag into a collapsed section.

Excited to hear what you think!

🔑 Dropdown display labels​

Note: This feature will be enabled and generally available starting on February 7, 2025.

Some input values are not user-friendly. There’s always that one person on the team who knows user #14925300281 is Jeff, but for the rest of us, displaying the name or email is way more helpful.

With dropdown input parameters, you can now select a display column to render (e.g., email) but still have it return the underlying value (e.g., User ID).

Other improvements​

• Faster first run for published apps: We reduced the number of cells that need to run for you to get your answer by only running upstream dependent cells. (Before this update, first runs for published apps ran all the cells — even if they weren’t in the dependency line.)
• Component upgrade notifications: Now when you publish a new version of a component, you can (optionally) notify all the folks who own projects consuming your component that a new version is available.
• Db2 data connection: We recently built a new data connection to support Db2. This feature is currently in private beta, so reply to this email if you’re interested in testing it out!
• Native decimal support for Snowflake: We now support larger numbers using the Python Decimal data type. In the Snowflake configuration panel, you can toggle on "Native decimal support" for up to 38-digit integers.

At Hex, December is a time for connecting, reflecting, and shipping! Others may slow down for the holidays, we cannot, we literally do not know how to do it, so here’s a tree full of presents we got for you, with much more on the way.

This week’s release has a bunch of improvements to much-used features like SQL and charts – but first, our most-requested feature…

🧮 Advanced compute profiles, now in GA​

They’re finally here: more powerful compute profiles and GPUs 💪

Our new compute profiles give you access to more memory and compute power, allowing Hex to meet the challenges of your most demanding workloads. Choose from a variety of amazing acronyms like 4XL (16CPU, 128GB RAM) and V100 GPU (6CPU, 56GB CPU RAM, 16GB GPU RAM).

These advanced compute options can handle any compute-intensive Python task, whether that’s offline-training for your fraud detection model, fine-tuning an OCR transformer with GPU’s, or just working with a massive dataset. Now you can do it all, right in Hex.

Advanced compute is billed per-minute of usage, and we’ve included admin controls for cost observability and management, including spend limits, access controls, and usage logs. Check out the blog to learn more.

🧭 Explorer workspace role​

When we introduced our “Explore” UI a few weeks ago, the first thing we heard was, “this is awesome, is there some way I can get this turned on for stakeholders?”

Well, the day has arrived: you can now provision users as “Explorers”. This allows them to start new Explores, Explore-from-Here in published apps, and subscribe to metric notifications (but not start full projects or write code).

This role is perfect for the data-literate folks in your organization who want to be able to slice-and-dice data or get updates, but don’t need the full firepower of a Hex Editor seat. Our product team wrote about the new Explorer workflows in a blog early this week - take a look!

Interested in getting this turned on for your workspace? Get in touch.

🫶 One-to-many and many-to-many no-code joins​

No-code joins in Explorations now support one-to-many and many-to-many join relationships.

Hex will automatically detect duplicate rows that arise as a result of your join, and using the unique keys specified in the join configuration, accurately calculate aggregations on both the base and joining table. Plus, Magic can now intelligently generate joins when you ask questions, making data exploration even simpler.

Don't worry about keeping track of these join relationships yourself - Hex will warn you if the join you've configured will lead to inaccurate results!

📈 Smarter chart labels​

One of you (not naming names!) sent some feedback calling our chart labels “trashy” because of their tendency to overlap and… honestly, you had a point!

As part of our never-ending quest to make charts in Hex beautiful, we’ve improved the way labels and axes are rendered including:

• Labels not showing in vertical bar charts if they don't fit vertically in their parent bar
• A new "auto" position option for line and area charts which will automatically layout the labels so they don't overlap with any lines or other line/area data labels
• We’ve also introduced a new “minimum tick step” setting on the y-axis.

Take a look.

We have many more improvements for charts on the way – including support for “wide” data and some nice performance boosts!

✍️ Better SQL autocomplete​

Speaking of things we’ve heard from you all about – SQL autocomplete. We’ve made some big improvements here:

• Autocomplete now activates for column names after a .
• Automatically re-open autocomplete panel after a previous activation – for example, if you select a schema name to autocomplete, we then re-open autocomplete with table names
• More consistent capitalization, using the previous alphabetic character in the SQL cell if there haven’t been characters typed

Our internal data team is loving the upgrades, hopefully you do too!

⤴️ Visualize pivot values as rows​

In the olden days, you used to only be able to visualize pivot values as columns, but now, in December 2024, we live in a miraculous future where you can view them as rows, too. What a time to be alive 🌅

🔗 Automatic markdown-style hyperlink rendering in tables​

It’s now easy to make pretty links in tables with automatic hyperlink rendering. When your data includes markdown-style links like [Hex](https://hex.ai), we'll automatically transform them into beautiful, clickable links - no more messy URLs cluttering up your tables!

Other improvements​

• You can now cancel queries fired off from explorations, so if you accidentally kick off a bigger-than-expected task, you can shut it down before it runs up your warehouse bill
• We now support relative line numbers in SQL and code cells, which will come as a delight for y’all nerds that have Vim key bindings enabled. To use, open the command palette (cmd+p) and choose “Toggle relative line numbers”

We’re turning on our new “Ask Magic AI” responses for data questions for all Team and Enterprise plans. Plus, embedding is coming to Hex! And for those of you who find yourselves in long, scrolly projects, we’ve got a brand new Marie Kondo-esque improvement to help you keep things tidy.

✨ Ask Magic - now with support for data questions​

Ask a question from the home page and get pointed to an existing app or a new Explore.

Magic now works outside of projects. Ask Magic a question and it will recommend existing published apps - a powerful new feature that “deflects” questions to trusted analyses. Say you want to know “what campaign is performing best this quarter?” Magic will point to the “Campaign Impact Dashboard” or whatever the relevant app is.

If the answer isn’t in an existing app, Magic will offer to create an Explore so even your no-code users can see, understand, and trust the response to their question. Not sure where to start? Try one of Magic’s suggested questions custom-created to your team’s data.

💡 Data Curation Suggestions​

Admins get suggested tables to endorse in a new area of the data browser called “Curation.”

Magic is really smart about SQL, Python, and analytics, but it can lack business context - like a new hire. You can help Magic the same way you can help a new team member, by curating the data in your workspace. With our new curation suggestions, Magic helps you help itself (and others). Curations automatically surface popular tables and datasets that Admins may want to endorse.

Curations can be accepted or dismissed. Magic will prioritize using endorsed tables when answering questions and generating suggested prompts in Ask Magic - helping your non-data team users ask the right questions and explore the right data.

Want a deep dive on how to best optimize your workspace for LLM's? Join our upcoming Magic & Data Curation conversation on Wednesday, December 4th or learn more about curation in our docs.

Our Magic team is looking for design partners! If you’re a workspace admin or leader excited about using Magic to help enable your team to ask and answer data questions we want to talk to you. Reach out to [email protected]

📊 Embedded Analytics (Beta)​

Embed a Hex App into your secure website with pass-through auth and row-level security.

By popular request, we’re bringing advanced embedding capabilities to Hex, so you can securely embed content for your customers. The beta includes pass-through authentication to allow your users to view embedded content without a Hex login, and row-level security to customize the data per user.

We have lots more on the roadmap, but if you’re interested in learning more about embedding, including questions about pricing, reach out to: [email protected].

🔄 Recent Explorations​

See and browse your history of Explorations so you can start up where you left off.

If you haven’t tried Explorations yet, this is your sign. If you have tried Explorations but didn’t bookmark one you meant to, accidentally closed your browser tab, or your cat walked on your keyboard, this is your solution. Now you get a 14-day history of explorations you created so they are easy to recover and re-open.

Find them in the Recents tab of your Explorations page.

🗂️ Collapsible Notebook Sections​

Group cells into sleek, nested, beautiful sections that collapse to keep your notebook organized.

People build some amazing – and long! – projects in Hex. And those super scrolly projects can get... a bit unwieldy. Many (many) of you have reached out asking for a better solution, and today is your day. Sections are groups of cells that can be labeled and nested within a project. Grab one cell at a time or select multiple. Move them in and out of sections with ease.

Your projects have never looked so put together.

Other improvements​

• The share dialog got a makeover. We simplified the buttons, tucked away some text and overall made it a whole lot cleaner.
• Data connections now have a new permission, Can view results, that can be used to limit who can view the results project that use sensitive data. This feature is available on Enterprise plans. Learn more in the docs.
• Magic now recognizes Snowpark data frames and will automatically include them in suggestions.

Today we're launching Explore — a powerful new way for anyone to analyze data in Hex without writing code. This release brings drag & drop analytics to Hex, along with major improvements to Magic AI, new semantic layer integrations, and data-driven notifications.

🔍 Explore: Visual Analytics for Everyone​

Build complex analyses by dragging dimensions and measures onto a visual canvas — no SQL or Python required.

Our new drag & drop interface lets business users answer their own data questions without constantly tapping the data team. Explore brings together several powerful capabilities:

• Visual Builder: Drag dimensions and measures to create detailed visualizations and tables
• Spreadsheet Calculations: Build custom logic using familiar spreadsheet formulas
• No-code Joins: Merge tables with automatic key detection and fan-out deduplication
• App Integration: Drill directly into the underlying data of any Hex app
• Notebook Chaining: Connect Explores with SQL, Python, or other Explores to build complex analyses

Explore is available as a cell in notebooks on all plans and as a standalone UI on Teams and Enterprise Plans.

🪄 Enhanced Magic AI​

Magic AI now helps anyone find the right data and start new analyses.

Ask Magic questions like "Which launch emails had the highest engagement?" and it will:

1. Recommend existing, endorsed analyses that might answer your question
2. Offer to start a new Explore to build the analysis from scratch

Enhanced Magic AI capabilities are currently in private beta. Email [email protected] to join.

📚 Semantic Layer Integration​

Sync your existing semantic definitions directly into Hex's data browser and Magic AI.

Your semantic models can now guide users to the right data across Hex:

• Import measures and join relationships
• Surface semantic concepts in Explore and the data browser
• Enhance Magic AI's understanding of your data

LookML sync is in private beta today. dbt MetricFlow integration coming soon.

🔔 Conditional Notifications​

Set up alerts when metrics hit milestones or encounter issues.

Users can now configure their own data-driven alerts:

• Set conditions based on metric values
• Receive notifications via email or Slack
• Choose between scheduled or data-triggered alerts

📅 Upcoming Explore Events​

Want to learn more about these new features? Join us for these upcoming sessions:

• Wed, Nov 13: Data Teams & Business Users: A Match Made in Hex - with CEO Barry McCardel
• Wed, Nov 20: Explore the New Frontiers of No-Code in Hex - with PM Sarah Tayeri
• Wed, Dec 4: A Little Magic, A Lot of Data, and Trusted Answers for All - with PM Olivia Koshy

Sign up through your Hex workspace or contact our team for registration details.

🔒 An update on Hex project permissions​

An important change is coming to Hex's project permissions

Previously, Viewers in a workspace could be given one of two different project permissions:

• Can view: Allows users to view the published app and the notebook of a project, including unpublished projects. This permission also allowed users to view data powering a chart, or explore charts and tables included in a published app if the user has an Editor seat.
• App Only: allows users to view and comment on only the published app.

We're updating these project permissions to the following on December 2.

• The Can view permission is being relabelled to Can explore to better reflect the capabilities included in this project role. Can explore permissions are only available to Editors.
• Viewers in a workspace can only be granted the Can view app project role, to ensure they are viewing work that has been marked "ready for consumption" by being published.

There are two consequences of this change for Viewers in a workspace:

1. Viewers will no longer be able to view the Notebook of a project. If a Viewer relies on unpublished notebooks as a source of information, consider publishing the project to give them access.
2. Viewers will no longer be able to use the View Data feature on a published app. If a Viewer relies on this feature to access a tabular version of a chart's data, consider updating the app to include a Table display cell

Until the changes take effect on December 2, we'll notify Viewers in-product if they are taking actions that will no longer be available.