Step 3: Create Buckets to Store Your Temporary Data - 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).

Step 3: Create Buckets to Store Your Temporary Data

Data migration from BigQuery to Amazon Redshift includes the following steps:

  1. Export data from BigQuery to a Cloud Storage bucket.

  2. Extract data from a Cloud Storage bucket.

  3. Upload data to an Amazon Simple Storage Service (Amazon S3) bucket.

  4. Copy data from an S3 bucket to Amazon Redshift.

You need all four steps because you can’t access data directly in BigQuery and you can’t upload data directly to Amazon Redshift. Because of these limitations, you need to create buckets to store your data during migration.

To create a Cloud Storage bucket

  1. Sign in to the Google Cloud management console.

  2. Open the Cloud Storage Browser page.

  3. Choose Create bucket.

  4. For Name your bucket, enter a name for your Cloud Storage bucket.

  5. On the Choose where to store your data page, choose Region for Location type and then choose your region for Location.

  6. Leave the default values for other options, and choose Create.

To create an Amazon S3 bucket

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/s3/.

  2. Choose Create bucket.

  3. For Bucket name, enter the globally unique name of your Amazon S3 bucket.

  4. For Amazon Region, choose the Amazon Region where you want the bucket to reside. Choose a Region close to you to minimize latency and costs.

  5. Leave the default values for other options, and choose Create bucket.