Case Study Netezza to Snowflake Migration

About Customer: Global Clothing Retailer

This case study is of a global lifestyle brand that continues to design clothes, fragrance, watches, footwear and more, with real-life in mind. Building on a heritage, simultaneously INNOVATING and challenging to have a FRESH and RELEVANT outlook, so they can create a VERSATILE and adaptable wardrobe.

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

Challenge

Navigating Constraints

The customer had deployed many stored procedures in Netezza which required work to be migrated, thus they wanted to avoid creating any native stored procedures to their future platform. Snowflake also was not ready to have their private preview of stored procedures used for such a complex production scenario. This introduced a major roadblock as the stored procedures were highly elaborate, and depended heavily on nested procedures. Additionally, the people that wrote the stored procedures were no longer employed by the customer. Thus, Intricity had to reverse engineer all the code which contained all the business logic. The customer also had many shell scripts that called the Netezza Stored Procedures. Every step in the stored procedures was logged in the Netezza deployment, and this level of logging was something that the customer insisted be kept in the future Snowflake deployment. This was because the people who wrote the stored procedures no longer worked for the customer. However, they could read the results of the logs and determine what to fix.

Read the full Case Study here: https://view.attach.io/BkqhJ4CWB