Problem
Advent Health faced challenges in delivering more reliable insights/analytics/reports across the enterprise after their Snowflake implementation. The core issues were related to poor data pipelines and testing that were slow and impacted IT’s ability to deliver analytics and reporting to their user community.
- Workflows with unclear dependencies
- Lack of Snowflake platform knowledge
- Version control issues impacting data integrity and collaboration
Solution
Evaluated and implemented Azure Data Factory to extract data from Snowflake. Developed ADF templates and best practices to help Advent Health scale and increase adoption.
Improved the validation and testing methodology to accelerate reporting and analytic deployments. The enhanced implementation reduced Snowflake’s query times and decreased processing costs.
- Integrated Azure Data Factory to Snowflake
- Rebuilt and consolidated the data pipelines and transformation scripts
- Trained Analytics Engineers on Snowflake best practices and architecture
