Amazon RedShift Copy Command
Specify the source region as below
copy pep.test
(operation, task_id, task_name)
from 's3://move-redshift-data-devo/move-redshift-data-devo/'
iam_role 'arn:aws:iam::355750824903:role/RedshiftDynamoDBAccess'
format as csv
region as 'us-east-1';
https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-source-s3.html#copy-region
The S3 bucket and redshift must be in the same region (US East):
This example uses an Amazon S3 bucket that is located in the US East (Northern Virginia) region. When you load data using a COPY command, the bucket containing your data must be in the same region as your cluster.
If your redshift cluster is in another region, look at Step 5: Load Sample Data from Amazon S3, scrolling to the table with region-specific-bucket-name:
------------------------------+-------------------------------+ | Region | region-specific-bucket-name | ------------------------------+-------------------------------+ | US East (Northern Virginia) | awssampledb | ------------------------------+-------------------------------+ | US West (Oregon) | awssampledbuswest2 | ------------------------------+-------------------------------+ | EU (Ireland) | awssampledbeuwest1 | ------------------------------+-------------------------------+ | Asia Pacific (Singapore) | awssampledbapsoutheast1 | ------------------------------+-------------------------------+ | Asia Pacific (Sydney) | awssampledbapsoutheast2 | ------------------------------+-------------------------------+ | Asia Pacific (Tokyo) | awssampledbapnortheast1 | ------------------------------+-------------------------------+