Case Study Teradata to Snowflake Migration at Major Retailer


About Customer

Intricity worked with a private department store based on the East Coast of the US with just under 300 stores located in 16 states and a growing digital presence. The retailer has a wide assortment of national brands and private label fashion apparel, shoes and accessories for the all age groups along with top name cosmetics, a wedding registry, and a large selection of quality merchandise for the home.

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 retailer had been a Teradata customer for 8 years. Over time the query speed of the retailer’s Teradata environment degraded, resulting in unacceptable turn around times for data science queries. The situation weighed down on the relationship between business and IT. Additionally, the retailer was faced with the constraints of an ever-encroaching Amazon footprint in the retail space. The retailer needed better inventory and customer analytic performance to ensure that they could compete with Amazon’s market presence. They decided to engage in a digital transformation which clearly Teradata was not capable of supporting. An evaluation was set up to test Snowflake against the same Monday morning stresses that Teradata had to endure. The results were a “no brainer” for them. Later in the sales cycle, Google BigQuery got evaluated, but they failed to produce the same level of simplicity and simplicity of conversion.

The retailer’s Teradata instance had 8 years of established integration code. To get their arms around the effort they produced complexity counts around the content currently connected to Teradata like utilities, initial load, ingestion, transfer & schedules, tables, views, and data volumes. Intricity leveraged these statistics to produce a fixed priced “lift and shift” migration proposal.

Read the full Case Study here: