Case Study - Data Migration to RedShift

Skybound RedShift Architecture
Data Migration to RedShift

The Challenge: 
Skybound needed assistance migrating their analytics data to a managed data warehouse solution. Stratus10 designed and implemented an automated solution to migrate their data to AWS.

Solution:
Stratus10 assisted Skybound in designing, automating, and implementing a solution that allowed them to export their My-SQL data to CSV files, upload them to an intermediate S3 Buckets, and perform an Extract, Transform, and Load (ETL) process using AWS Glue - a service that prepares data for analysis through automated extract, transform and load (ETL) processes. This allowed us to prepare the data in order to match the client's database schemas and finally load the data into an AWS Redshift cluster.

Use case: Data Warehouse Migration

Client:

Skybound

Date:

December 11th, 2019

Category:

RedShift / Migration