Hex's Partnership with Snowflake: Behind the Magic

Hex, a data science and analytics platform, has partnered with Snowflake to create seamless workflow features for professionals. The company's CTO and co-founder, Caitlin, discussed the various features developed in collaboration with Snowflake at a recent talk. One of the key issues addressed by Hex is the reproducibility problem associated with traditional notebooks. To tackle this issue, Hex automatically parses code and builds a directed acyclic graph (DAG) to ensure that every time a cell is run, all cells it depends upon are run in the same order. This DAG structure has been instrumental in developing several features, including AI-assisted queries, intelligent prompt engineering, and a polyglot workflow allowing users to move between SQL and Python. Hex also leverages Snowpark Container Services (SPCS) for enhanced data security and governance, enabling all of its operations within the user's Snowflake account.