Troubleshooting Amazon Redshift Connection Errors
A task that writes to Amazon Redshift fails with the following error:
Amazon_RedshiftWriter_30007 [ERROR] Copy command on record 'public.basic_data_types' failed due to [ERROR: S3ServiceException:The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.,Status 301,Error PermanentRedirect,Rid A8BA401CC765AC53,ExtRid NAbd1uxKirJVjDas1zo3WONdQ/+6p674RYkO
The Amazon Redshift user and cluster in the connection properties are in a different region from the S3 bucket in the task.
Configure the task to use an S3 bucket in the same region as the user and cluster in the connection. Or, use a different connection to write to the S3 bucket.