Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Troubleshooting Amazon Redshift connection

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.