Hex's Partnership with Snowflake: Behind the Magic

This post details Hex's partnership with Snowflake, focusing on the technical implementation of features that integrate Hex with Snowflake's capabilities. It explains how Hex leverages Snowflake's data warehouse scale through features like Query Mode, which automatically builds CTEs to keep computation at the warehouse level. It also elaborates on the polyglot workflow, detailing the technical approach to seamlessly move between SQL and Snowpark dataframes, including how SQL queries are wrapped in sessions to create Snowpark dataframes and how Snowpark dataframes referenced in SQL queries are handled by creating temporary tables. Furthermore, it discusses the deployment of Hex within Snowflake using Snowpark Container Services, enabling data, compute, and user management to reside within the Snowflake account.