Skip to main content
Latest release:

Yep, we went there. You can now select "Dataframes" as a data source for SQL cells, and query any dataframe in a project like a table in a database. Queries are fast, in-memory, and use a well-featured flavor of PostgreSQL.

You can use Dataframe SQL to break up large queries into modules that are "chained" together, join tables across databases and CSV sources, or just pop back into SQL halfway through an analysis to do a simple filter or case statement. You can mix and match SQL and Python on the same data as many times as you'd like!

There's a lot to say about this one, so we wrote an entire blog post with the "why" behind the feature. Just in the mood to get started? Check out the docs for the full details and jump right in.

🚦Project organization​

Bring some order to the chaos and organize all of your Hex projects! You can now add a Status and multiple Categories to any Hex project and filter the main Projects view to quickly find what you're looking for.

We've set you up with some default options to get you started, but any Hex administrator can add new Categories or Statuses from the Administration page. And yes, you can remove the defaults if you've got your own big plans πŸ™‚.

πŸ–₯️ View Live button​

We saw that you generally only clicked the πŸ‘οΈ button in the menubar to access the "View Live" button contained within, so we pulled that button out to the top level. You can now click this πŸ–₯️ button to go straight to the live version of your app.

πŸ•΅οΈβ€β™€οΈ SQL Query metadata​

To help admins keep track of database usage, SQL queries now include a comment with helpful metadata about the Hex user and project that ran the query.

πŸ“Š Binning in Chart cells​

Chart cells now support binning, which means you can create histograms right out of the box!

πŸ•΄ Performance improvements​

We have made some big improvements to speed in Hex: loading projects is much snappier, project run times are faster, and little things like adding new cells take less time. Performance work is never done – let us know if there are any other areas that you think could use a little speed up πŸš€

ℹ️ SQL query information​

SQL cells now offer more context about a query, including when it ran, how long it took, and whether it is coming from a cached version or not.

🀫 Shared secrets​

Like Shared Data Connections, Shared Secrets allow Admins to create secret values that can be used across projects.

Note: Shared Secrets are visible to all Editors in an organization.

🚨 Email alerts for failed scheduled runs​

Project Owners will now receive an email when a scheduled run fails. Along with the new Scheduling sidebar, this makes it easier to understand when and where projects might be running into issues.

πŸ” Input Parameter cell updates​

We made a bunch of updates to Input Parameter Cells. They now include a Run Button, which makes it easy to Run Below after changing a parameter value.

They also include a new "Referenced In" element, which let you quickly see and jump to downstream cells in the project that use the given parameter in their code.

πŸ’¬ Live chat relocated​

Don't fear, you can still drop us a line any time with our live chat support, we've just tucked the button out of your way in the bottom left corner of the screen. You'll also find a link to the help docs and this changelog there too!

Lots of great updates this week, but first...

♻️ A note on iteration​

We're big champions of building iteratively β€” this means that we take your feedback very seriously as we incrementally add the Hex features that make your data life easier. (So a big thank you to everyone who's shared their thoughts!)

With that note, we're excited to (re)share two features which have had some big updates: the File uploader and Schema browser! Keep scrolling for more details.

πŸ—ƒοΈ File uploader 2.0​

Among the many things that a year+ of WFH has taught us is that home internet upload speeds are not great. We've revamped our File Uploader so that you can not only upload multiple files at once, you can do so in the background with no time limit! You can also download your files to your local computer.

πŸ‘“ Schema browser 2.0​

Our Schema Browser can now handle larger, chunkier schemas! We've also added the ability to search through your data, reference multiple databases within a data source, and manually trigger a schema refresh.

πŸ‘Ÿ Run mode options​

We've unlocked more options for how cells execute while you're in Notebook view. "Cell + above", "Cell + below", & "All cells" are execution modes which can now be set as a project-wide default or triggered at the individual cell level. Check out the docs or the video below for a breakdown!

🧺 SQL goodie basket​

We're making the SQL editing experience in Hex better and better. This batch of improvements includes:

  • Type-ahead β€” use the suggested schema and table names without having to do all that typing! (See a sneak peek in the screenshot above)
  • Better error messages β€” we've condensed SQL cell errors to make them more helpful
  • SSH data connections β€” access databases on private networks with a secure SSH tunnel
  • Compiled query β€” see the query you've written as a compiled prepared statement for easier debugging

Bugs squashed​

  • The item limit for dropdown menus has been increased to 1000 items and a warning when that limit is passed has been added.
  • Some markdown cells were not automatically being added to Story mode apps, which has been resolved.
  • Error message from cached queries are no longer suppressed.
  • HTML outputs no longer have a fixed size.
  • Auto highlighting of a project name has been added to the renaming project workflow.

A bunch of new features and improvements for you this week. Let us know if there's something you want to see us build next!

πŸ“‚ Persistent files​

We've upgraded Projects so that now any files you write persist from session to session (even after kernel restarts). You'll see your files added to the left side panel as you create them, along with any files you've imported with the File Uploader.

βž• More data connections​

Welcome Athena and MS SQL Server to the Data Connection family! Like with all the other data sources, just fill in your connection details and you can hit your database directly using our SQL cells.

Other improvements​

  • Query Details: We now show you the number of rows and total size of the data you're returning right in the SQL cell!
  • Schema Browser Performance: We've put some elbow grease into our Schema Browser performance - it runs much, much faster.
  • Chart Cell Improvements: You can now customize your axes' labels! Also, we've enabled sorting! Stay tuned for more soon…

Bugs squashed​

  • Issues with copy and paste actions, as well as other cell focus issues, have been resolved.
  • Input parameters and Run options in Snapshots no longer appear as editable.
  • Extremely large database schemas no longer cause Schema Browser errors.
  • The query cache refresh button now correctly forces a new execution of a query.
  • Queries with JOINs which were failing due to non-nullable columns are now supported.
  • Exporting SQL cells to .ipynb files has been improved; other cell types no longer result in malformed .ipynb exports.
  • Roles are now correctly displayed when hovering over collaborator's icons.
  • The icons for elements in Story mode are now easier to interact with and no longer prevent hiding elements.

🚩 @-tagging​

Tag, you're it! We've added @-tagging to comments so you can direct your thoughts to individual teammates.

πŸ”‚ Scheduled run history​

Your scheduled projects execute like clockwork. We've added a record of all your project's scheduled runs so that you can check their success and see exactly what was executed!

Bugs squashed​

  • Input Tables temporarily refreshed with every cell changed, which has been fixed.
  • Display Tables now accept columns with '.' in their name.
  • The problem with caching large queries running out of memory has been resolved.
  • Command Palette actions have been re-enabled after being temporarily unavailable.
  • Date-type Input Parameters can now have null values.
  • BigDecimals in BigQuery are now supported.