The overall flexibility of the tool is fantastic. I love being able to segment complex queries into different blocks, switch between SQL and Python, and to collaborate with coworkers directly in an IDE. Review collected by and hosted on G2.com.

I wish Hex could surface code errors before running queries, similar to BigQuery's out of the box IDE. I would like the ability to snooze/comment out blocks rather than physically commenting out the code. Direct AI coding assistant integration would be nice. The graph is helpful but hard to navigate Review collected by and hosted on G2.com.

I quite like the notebook to app workflow and sharing capabilities. Creating a notebook from scratch, building out a replicable analysis, and sharing that with colleagues is a breeze with Hex. The SQL caching feature is quite nice as well to allow for faster notebooks coupled with sharing. Review collected by and hosted on G2.com.

You can redefine variable names in different cells. This leads to one of Hex's main features not executing well. A traditional jupyter notebook runs top to bottom sequentially. With Hex, a graph is created. If I want to run the 30th cell then Hex uses the graph to understand what stale cells above it should also be run. This is great, until you redefine variables in different cells which leads to less of a gain from this feature. Review collected by and hosted on G2.com.

I like that Hex combines the usage of SQL and Python, unlike Jupyter notebooks. It has an easier way of creating charts, pivots, and tables. The pivot feature with calculated columns is the one I find most helpful, and the chart cells as well. These features save me a lot of time because I would have had to write code to perform these actions otherwise. The Pivot Hex cell is great because even a non-technical person can just drag and drop to adjust things. I found the initial setup fairly easy due to the documentation. Review collected by and hosted on G2.com.

Sometimes the cells cause errors without any changes to the code or formula, which is frustrating because there's nothing to debug. This annoys me a lot. Also, there could be more chart types available for a more detailed analysis. Review collected by and hosted on G2.com.

- great visualization options

- highly flexible, dependency awareness between cells is very strong

- easy transition between python and sql

- responsive and kind customer support / team

- fast moving company, they keep adding new and useful features all the time

- easy to use

- reusable code components

- best AI integration in an analytics tool so far (still behind an experience like cursor though) Review collected by and hosted on G2.com.

- github integration is weak. I wish it was possible to push changes via github. For data analysis and exploration hex is quite good but I also use it for internal tooling since it supports python and for those use cases I prefer to write code in cursor and push to hex.

- auto complete could have been much better

- cells that return "query" (instead of dataframe) is a great idea but the implementation is not good. It tries to show you a sample of data so if your query has heavy joins it takes forever. because of this, for reusable CTE's I need to use python which is not a seamless experience Review collected by and hosted on G2.com.

I'm using Hex on a daily basis. It's very intuitive. I haven't done hands on data work in awhile and Hex made it easy for me to jump back in. Using the integrated AI I was able to find the information I wanted and it was helpful in extracting the information I needed quickly. It also made it easy to create quick apps using sql and python, schedule a job and integrate with other systems. Review collected by and hosted on G2.com.

Working with other data clients, I remember one helpful feature was the results have been saved in tabs. In Hex, every time I run a query it overwrites the previous results. Would have been nice to still see them in a tab. Review collected by and hosted on G2.com.

I love using Hex for data analytics because of its notebook feature, which allows me to continue my work effortlessly and slice up data in various ways for a deeper analysis. The direct connection to Snowflake makes accessing data super easy, and the AI agent has become quite good, eliminating the need for other AI tools in my analysis. The AI agent understands context well, is fast, and reasons effectively, making data exploration and complex SQL queries a breeze. Review collected by and hosted on G2.com.

nothing Review collected by and hosted on G2.com.

Quick easy analysis without needing to setup connections and environments Review collected by and hosted on G2.com.

Currently wr cqn only connect 1 external github library to a given hex project Review collected by and hosted on G2.com.

Hex is the most impressive analytical environment I have used so far. What impresses me most is how effortlessly Hex connects SQL and Python dataframes, allowing for smooth transitions between the two. I also value the intuitive visualization tools, including tables, pivots, and charts, which are simple to use without any additional setup. The data caching functionality is another strong point, as is the ability to connect to and manage multiple databases at once. ONe more feature worth to be mentioned is Components. And the last but not least is easiness of transforming notebooks into published apps. Review collected by and hosted on G2.com.

Hex provides an excellent feature that allows you to reuse SQL query cells as CTEs in later SQL cells. However, this functionality comes with a frustrating drawback. When working in Notebook mode, you must execute the CTE cell before running the final query, which effectively doubles the execution time. Review collected by and hosted on G2.com.

What I like best about Hex is how it combines coding, analysis, and collaboration in one place, making it easy to go from data to insights quickly while working seamlessly with a team. Review collected by and hosted on G2.com.

One downside of Hex is that it can feel a bit complex for beginners, especially if you’re not familiar with SQL or Python, and some workflows can take time to fully get used to. Review collected by and hosted on G2.com.

The AI agent to help run/create queries is great! As a person that is new to SQL and database structures, this has been incredibly helpful to use with natural language. Review collected by and hosted on G2.com.

The speed of the publish feature from notebook to app could be faster. The delay can cause confusion and frustration when trying to make a fast update to release to users. Review collected by and hosted on G2.com.