No Offense to Google Bigquery, But here is how to migrate to Amazon Redshift

… a strategic approach to modernize Data warehouse on Cloud

If you are like me, you have already witnessed the world of legacy data warehouses, you have spent nights on enterprise historical data loading, transforming, and creating the stories out of data. Then, in evolution, you have also appreciated big data and various technologies.

Then, here comes the cloud.

One thing never changed, and that is the growth of data bytes. Beyond MB, GB, TB, PB, EB, and so on. (Yes, I’m embarrassed to write KB )

Let’s explore two modern Data warehouses Google Bigquery and Amazon Redshift; then in our use case, we’ll plan steps in migration from Google Bigquery to Amazon Redshift in the sections.

1. A Tale of Two Cities: Google BigQuery and Amazon Redshift

Google BigQuery (BQ) and Amazon Redshift (RS) are cloud-based EDWs (Enterprise Data Warehouses) that support SQL queries on large datasets.

About the Cloud-based Data warehouses: Google’s Bigquery and Amazon Redshift

2. Why move from Google BigQuery?

Google BigQuery (BQ) is a powerful big data analytics platform. However, many customers are finding that it doesn’t meet their…