Victoria’s Secret and Bath & Body Work’s Platform Modernization Journey to Snowflake
/1
Explore the transformation potential in your business
/ Assessment
- Get answers to key questions
- Will it make sense to design my future-state architecture using all Snowflake-native services (for data processing and storage, orchestrating, analytics, BI/reporting, etc.)?
- What should be the optimum auto-scaling rule for my Snowflake cluster based on my reporting needs?
- Can I save provisioning and maintenance costs for rarely used workloads on Snowflake?
- Data warehouse
- Can I get schema optimization recommendations for partitioning, clustering, and more?
- ETL
- Will my ETL processing SLAs impact my choice for an optimum Snowflake cluster size?
- Analytics
- Will it be beneficial to convert analytical functions to Spark libraries or some native AWS functions?
- Will my ETL processing SLAs impact my choice of an optimum Amazon EMR cluster size?
- Hadoop
- Is my optimization strategy for Update/Merge apt for Snowflake?
- Can I get schema optimization recommendations for partitioning, clustering, and more?
/ transformation
- Packaging for and orchestration using Snowflake-native services
- Intelligent transformation engine, delivering up to 95% automation for:
- Data warehouse –Snowflake
- ETL – Snowflake
- Analytics – Snowpark on Snowflake
- Hadoo – Snowflake, Presto query engine
/ validation
- All transformed data warehouse, ETL, analytics, and/or Hadoop workloads
- Business logic (with a high degree of automation)
- Cell-by-cell validation
- File-to-file validation
- Integration testing on enterprise datasets
- Assurance of data and logic consistency and parity in the new target environment
/ operationalization
- Productionization and go-live
- Capacity planning for optimal cost-performance ratio
- Performance optimization
- Robust cutover planning
- Infrastructure as code
- Automated CI/CD
- Data warehouse – Provisioning of Snowflake and other AWS services for orchestration, monitoring, security, etc.
- ETL – Provisioning of Snowflake and other required services
- Analytics – Provisioning of Snowflake and other required services
- BI/Reporting – Provisioning of Snowflake
- Hadoop – Provisioning of Snowflake and other required services
/2
/2
Watch LeapLogic in action
Automated DataStage ETL workload transformation to Snowflake
Automated workload transformation from Oracle to Snowflake
Automated workload transformation from Spark and Hive to Snowpark
/3
Explore resources to support your transformation initiatives
CASE STUDY 
Hadoop modernization to Snowflake enabled a single source of truth
WHITE PAPER
Automated transformation of ETL, data warehouse, and analytics to Snowflake
Webinar
Automate data warehouse to Snowflake migration
/4
Learn more about these benefits and best practices for cloud-native transformation
