Migrating a BigQuery Project to Amazon Redshift - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Migrating a BigQuery Project to Amazon Redshift

This walkthrough gets you started with heterogeneous database migration from BigQuery to Amazon Redshift. To automate the migration, we use the Amazon Schema Conversion Tool (Amazon SCT) that runs on Windows. This introductory exercise provides you with a good understanding of the steps involved in such a migration.

At a high level, the steps involved in this migration are the following:

  • Use the Google Cloud management console to do the following:

    • Create a service account, which Amazon SCT can use to connect to your source BigQuery project.

    • Create a Cloud Storage bucket to store your source data during migration.

  • Use the Amazon Web Services Management Console to do the following:

    • Create an Amazon Redshift cluster.

    • Create an Amazon Simple Storage Service (Amazon S3) bucket.

  • Use Amazon SCT to convert source database schemas and apply converted code to your target database.

  • Use data extraction agents to migrate data.

To see all the steps of the migration process, watch this video.

This walkthrough takes approximately three hours to complete. Make sure that you delete resources at the end of this walkthrough to avoid additional charges.