Step 3: Upload the files to an Amazon S3 bucket - Amazon Redshift

Step 3: Upload the files to an Amazon S3 bucket

In this step, you create an Amazon S3 bucket and upload the data files to the bucket.

To upload the files to an Amazon S3 bucket
  1. Create a bucket in Amazon S3.

    For more information about creating a bucket, see Creating a bucket in the Amazon Simple Storage Service User Guide.

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

    2. Choose Create bucket.

    3. Choose an AWS Region.

      Create the bucket in the same Region as your cluster. If your cluster is in the US West (Oregon) Region, choose US West (Oregon) Region (us-west-2).

    4. In the Bucket Name box of the Create bucket dialog box, enter a bucket name.

      The bucket name you choose must be unique among all existing bucket names in Amazon S3. One way to help ensure uniqueness is to prefix your bucket names with the name of your organization. Bucket names must comply with certain rules. For more information, go to Bucket restrictions and limitations in the Amazon Simple Storage Service User Guide.

    5. Choose the recommended defaults for the rest of the options.

    6. Choose Create bucket.

      When Amazon S3 successfully creates your bucket, the console displays your empty bucket in the Buckets panel.

  2. Create a folder.

    1. Choose the name of the new bucket.

    2. Choose the Create Folder button.

    3. Name the new folder load.

      Note

      The bucket that you created is not in a sandbox. In this exercise, you add objects to a real bucket. You're charged a nominal amount for the time that you store the objects in the bucket. For more information about Amazon S3 pricing, go to the Amazon S3 pricing page.

  3. Upload the data files to the new Amazon S3 bucket.

    1. Choose the name of the data folder.

    2. In the Upload wizard, choose Add files.

      Follow the Amazon S3 console instructions to upload all of the files you downloaded and extracted,

    3. Choose Upload.

User Credentials

The Amazon Redshift COPY command must have access to read the file objects in the Amazon S3 bucket. If you use the same user credentials to create the Amazon S3 bucket and to run the Amazon Redshift COPY command, the COPY command has all necessary permissions. If you want to use different user credentials, you can grant access by using the Amazon S3 access controls. The Amazon Redshift COPY command requires at least ListBucket and GetObject permissions to access the file objects in the Amazon S3 bucket. For more information about controlling access to Amazon S3 resources, go to Managing access permissions to your Amazon S3 resources.

Next step

Step 4: Create the sample tables