Case Study SQL Server Refactoring to Snowflake Migration


About Customer

This global manufacturer is one of the world’s leading makers of tissue, pulp, packaging, building products, and related chemicals. Their customers span retail, commercial, government, aerospace, mining, facilities management, and a host of other application types.

About Intricity

INTRICITY is a team of specialized Data Management, Data Warehousing, and Business Intelligence experts. The team members at INTRICITY have been handpicked over the course of 20 years, and represent the top talent globally in Data-oriented disciplines.

Challenge and Wins


The CLIENT was still in the early evaluation stage of determining what platform they would be moving to. Their holding company and made a strategic decision that AWS would be their strategic direction moving forward. However, specific directives within AWS were still being determined. One of the data warehouses which would be impacted by this decision was their SQL Server-based Warehouse. The manager of this warehouse was looking for solutions besides a straight lift and shift that might modernize their SQL Server-based DW.

Navigating Constraints

Snowflake had not yet been accepted as the platform of choice for Data Warehousing within the CLIENT. Thus the team that owned the SQL Server environment needed to stay within a very tight budget while proving that Snowflake would be a good target platform off of their existing SQL Server deployment.

Read the full Case Study here: