Changelog

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!)

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

📃 Text wrapping​

Long text fields? No problem. You can now configure columns in our Table Displays to text wrap!

🔃 Rename query results​

Rename the dataframe returning your query results with a click! Just edit the grey "Returned as dataframe" title and hit enter. You no longer need to re-execute your query for the change to take effect.

A bunch of new features are coming your way. Let's jump right in!

⏰ SQL query caching​

Now you can set your SQL cells to use cached results and configure them to re-execute only when you want them to! Head to the docs for more details on the configuration options available.

✅ Multi-select Input Parameters​

Life's about having options. Use our Multiselect input parameter to let users choose the list of things they need!

🗞️ Sharing simplified​

The new Share dialog box simplifies how to share your projects. See permission details in our docs.

📦 Package upgrades​

We've bumped some base packages to more-recent versions:

pandas==1.2.1
numpy==1.19.5
scikit-learn==0.24.1
statsmodels==0.12.1
tensorflow==2.4.0
tensorflow_hub==0.11.0

Welcome to a New Year with Hex! 🎉 We're revved up to deliver some amazing features this year and can't wait to share them with you.

🖼️ Snapshots​

Data changes, analyses change, people change — with Snapshots you can freeze your results in time and go back to them for easy reference.

Along with Snapshot you can now enable collaborative App sessions by linking to the exact view of the App you want; because we know that when you're collaborating with stakeholders it helps if everyone's all looking at the same data (😅).

🏠 Sidebar re-organization​

We've made it easier to access the details of your Projects without having to leave the Notebook view of your work. All of your Data Connections, Secrets, files, and more have joined the Project Outline in the left sidebar — check out their new home!

🔜 Looking forward to 2021​

Hex started 2020 as an itch our co-founders just had to scratch. A year later our team has tripled (we're still hiring!), we've built (what we like to think is) a beautiful product, and (perhaps most importantly) we've learned a lot from all of you.

Hex lives by a "we're all in this together" philosophy. While there's no doubt that 2021 will be a challenging year, we're confident that by working together it can be a time to deepen relationships with the Hex community as we continue to build a platform that enables data-minded folks to unleash their ingenuity & creativity.

We're all in this together — tell us how we can make your analytical life better, what you think about the features we're building, & what you wish Hex could do. We're excited to build something great with you.

Other improvements​

• gspread, df2gspread & gspread-dataframe have been added to the default package list for all your Google Sheets connection needs
• Array-type columns can now be returned for BigQuery queries
• Cell outputs no longer scroll, allowing for easier visual comparison of returned outputs

Bugs squashed​

• Pandas stylized table formatting has been fixed
• Some html tables which were not rendering now display correctly

🔘 Run buttons​

The newest addition to the Input Parameter family, the Run Button is designed to let you control when code executes. Run Button parameters return a simple Boolean that only evaluates to 'True' if a Project run is the result of a button press.

Say you need to wait for user input before writing back to your database, or maybe you have a bunch of debugging code you don't want to always run - use a Button. Check out the demo video in the section below to see it in action!

🎛️ Pre-load data into Input Tables​

Extending the happy family metaphor —Input Tables are growing up before your eyes! Now you can use a dataframe to pre-populate Input Tables. Users can still edit table values, which are returned as a new DataFrame (and you can reset to the source DataFrame at any time).

Now what happens when you mix Input Tables & Run Buttons? You unlock a whole new workflow! See an example project demoed below:

🔗 Get connected with BigQuery​

Along with all of our other data connection options, we now support Google Big Query. Fill in your connection details and hit your database directly from your Projects using our SQL cells.

Other improvements​

• Got big data? Now you can upload individual files up to 2GB in size with our File Uploader
• Input Parameters can be passed through to nested SQL functions
• Boolean columns are now supported in Display Tables, in addition to the standard string and number types.

Bugs squashed​

• Modifier keys for Windows keyboard shortcuts fixed
• Some Data Connections were unable to be deleted, which is now fixed