Skip to main content
Latest release:

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.

๐Ÿ’ฌ App commentsโ€‹

Keep the conversations going with App Comments! Now you can engage your collaborators directly in the Apps you share (hopefully skipping all that back and forth on Slack).

๐Ÿ” Query detailsโ€‹

It's nice to know what to expect from your queries and to track their progress. We now show you the number of rows and total size of the data you're returning right in the SQL cell!

Can't remember your table or column names, let alone column data types? You can now browse your database schemas using the schema browser, available in the left side bar with your Data Connections.

Lots of features in this one! Read more for the full list :)

๐Ÿงฎ SQL parameterizationโ€‹

Play Mad Libs with your {{queries}} and parameterize them to your heart's {{content}}. Now you can pass both Input parameters as well as Python variables (including lists!) to your queries. Learn more in the docs or watch a quick video.

๐Ÿค Shared data connectionsโ€‹

Tired of having to create the same connection over and over? We hear ya. Now Admins can create shared connections that everyone can use!

Here's your chance to be internet famous! Turn on public share links so that anyone can interact with your Apps without needing a Hex account!

Other improvementsโ€‹

  • Python processes that would OOM your kernel now return a "Memory Error" message instead!
  • We've added a progress bar for when you !pip install packages.
  • We fixed a bug so that .ipynb files with raw cell types can be uploaded as projects.
  • We've added a couple packages to the base image: datarobot and pyodbc

We've been heads down building some great features for you. Let's dive in!

๐Ÿ“Š Chart cellsโ€‹

Create beautiful visualizations without memorizing tricky syntax (or combing through Stack Overflow ๐Ÿ˜…)! Learn more in our docs or check out this more in-depth demo:

๐Ÿง  Split-screen viewโ€‹

Maybe you can't pat your belly and rub your head at the same time, but now you can definitely work on the Notebook and App views of your projects simultaneously! No more switching back and forth as you put the finishing touches on your apps.

๐Ÿ”Ž Variable explorerโ€‹

See the objects defined in your project at a glance with the new Variable Explorer, located in the Variables tab of the left side panel!

Bugs squashedโ€‹

  • Booleans can now be used in dynamically defined Multiselect and Dropdown parameters (s/o to CP)
  • Intermittent issues with executing SQL cells with keyboard shortcuts has been resolved
  • Display Table pagination no longer hangs
  • Cells occasionally not registering keystrokes issue has been resolved
  • Display Tables were (temporarily) editable, but are now correctly immutable
  • Plotly auto-sizing of charts issue resolved
  • Cell menu keyboard shortcut typo fixed (good eye MW!)