'AWS Redshift COPY on S3 incorrect bucket region in ap-southeast-1

I had setup an AWS Kinesis Firehose (delivery stream) on ap-southeast-1. Both Redshift and S3 were also setup on ap-southeast-1. I used Kinesis Firehose to allow Redshift to manifest S3 bucket. Code:

COPY firehosetransactions FROM 's3://firehoseredshift-switt/<manifest>' CREDENTIALS 'aws_iam_role=arn:aws:iam::<aws-account-id>:role/<role-name>' MANIFEST json 's3://firehoseredshift/jsonpaths.json';

However, in Redshift the zone is showing as ap-southeast-1c. From my understanding, it is still in the same region but Destination error logs showed "Redshift.IncorrectBucketRegion".

Redshift attempted to use a bucket in a different region from the cluster. Please specify a bucket within the same region as the cluster. ERROR: Problem reading manifest file - S3ServiceException:The S3 bucket addressed by the query is in a different region from this cluster.,Status 301,Error PermanentRedirect Detail: ----------------------------------------------- error: Problem reading manifest file - S3ServiceException:The S3 bucket addressed by the query is in a different region from this cluster.,Status 301,Error PermanentRedirect,Rid

Are there any suggestions how to solve this problem? Thanks



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source