Datawarehouse Migration for a Leading Healthcare Company in USA

About Company

One of the leading healthcare AI company. Founded in year 2011. Host their data warehouse environment in AWS Redshift. Company helps healthcare systems prevent harm and lower costs. The system provide quality, cost-effective and patient focused care for some of the complex patients. Also, maintains the data of patients more accurately.

Project Summary

Migrating AWS Redshift to Azure SQL Data Warehouse. Azure SQL Data Warehouse has a pause and start function, is a high performance, lower-cost solution with an ability to scale and compute storage, less time is involved in installation and maintenance, includes various demographics tables and could run some queries in order to extract patients information.

Challenge

Migrating from AWS Redshift to Azure SQL Datawarehouse. Also, migrating queries from AWS Redshift environment to Azure SQL Datawarehouse environment.

Solution

We used PolyBase which uses T-SQL to join data which will help to move data from AWS Redshift to Azure SQL Datawarehouse. We moved data into the internal table and used PolyBase to run queries on external table, we performed migration using different customer designed queries.