Business Intelligence, News, Article, Blog

Case Study Netezza to Snowflake Migration

Admin

Admin

July 16, 2019

Untitled-design-5-450x222

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

Related Post

Case Study: Transforming Water with Snowflake's Data Platform

Read about how the Snowflake data platform is being leveraged by INTRICITY and its client to deliver efficiencies in water networks

Learn More

Case Study: Snowflake Financial Services End-to-End Deployment

Intricity Financial Services roll out of Snowflake. A strategy to execution case study.

Learn More

Here's What's Coming Up in the New Year!

Here's what's coming up in January 2021. We have a new Data Sharks videocast plus two webinars!

Read More