One of the top request features has arrived: Dynamic Markdown! You can now use variables directly in markdown cells!
You may also notice that the formatting has gotten a glow up. Header fonts are bigger, there are more header options, and fonts are now consistent between Logic and App views.
Sometime you just need to move a block of cells, duplicate them, or copy them to a different section of your project. We've added the ability to select multiple cells (shift + arrow) and adjust them as needed, all from the comfort of your keyboard!
We know some of you have some meaty queries and code cells (definitely not looking at you, you thousand-line-query-writers!). We've added cell line numbers to make navigating those beasts a little easier.
Maybe not glamorous, but security is fundamental to how we are building Hex. We're excited to announce that we now have a SOC2 Type II report!
The tl;dr — we take security seriously, so much so that an external auditor agrees that our systems and processes are secure, and that we adhere to them in practice. Read more details on our blog.
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!