One of our first projects we took on when we started engaging with Skybound was to rebuild and migrate their existing Data Warehouse from Rackspace to AWS. Skybound’s Data Warehouse is a giant database where one single table has over 430 million rows that stores data from multiple sources and is integrated with Tableau for advanced data visualization and reporting.
The original Data Warehouse code was a mess of scripts and cron jobs scattered across a server. We had to not only manage migrating database tables with millions of rows of records from one cloud provider to another (the database was so big that the traditional AWS migration tool failed and we had to script the entire thing by hand table by table), but we also had to reverse engineer all of the existing scripts and rebuild them with best practice PHP in Laravel.
The solution was to migrate Skybound to a modern API application built with Laravel hosted on AWS
The result of this massive project is a scalable data infrastructure which we help to maintain and further scale. The previous solution required constant maintenance and management to keep all of the scripts and crons running properly. Now we have a scalable API system that we can continue to grow with new data and integrations.
