Invalid operation: S3ServiceException:The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.Some Googling will tell you that this means that the S3 bucket and the Redshift cluster are not in the same region. However, both the cluster and the bucket reside in region ap-southeast-1 (Singapore). Specifying the REGION command with this region code doesn't help and the same error returns.
copy dim_products from 's3://s3-ap-southeast-1.amazonaws.com/dwh-dimensions/dim_products.csv' CREDENTIALS 'aws_access_key_id=MyAccessKey;aws_secret_access_key=MySecretKey' delimiter ';' timeformat 'YYYY-MM-DD HH:MI:SS' REGION 'ap-southeast-1';
From novice to tech pro — start learning today.