Less pipelines, more shipping: Renaissance’s journey to Hasura with Snowflake

Renaissance, an educational software company, has standardized on the Snowflake Data Cloud for their analytics and reporting needs. They recently decided to surface some of the rich insights from Snowflake in one of their new applications, tentatively referred to as the Teacher Journey, to view insights and recommendations for their students from across all of Renaissance's products. After attempting a few DIY options, Renaissance settled on the Hasura-Snowflake connector as their preferred solution for pulling the required data from Snowflake into the app via APIs. The team used a combination of lambdas, SNS topics, and SQS queues to push the required data from Snowflake into PostgreSQL. However, they faced issues with data integrity and pipeline management. Using the Hasura Snowflake connector meant no more unwieldy pipelines; instead, Snowflake is now the operational store for the new application. The smooth migration and simpler architecture was a great start. The team uses advanced Hasura features, including authentication via JWT and row-level permissions. They’ve also started experimenting with Hasura observability.