Amazon Redshift Connectors

Back Next

Troubleshooting Amazon Redshift connection

When you run a task to write data to an Amazon Redshift, the task 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; This issue occurs because the Amazon Redshift user and cluster in the connection properties are in a different region from the S3 bucket in the task.; You must configure the task to use an S3 bucket in the same region as the user and cluster in the connection. You can also use a different connection to write to the S3 bucket.

Watch

Comments