All geek questions in one place

Amazon RedShift Copy Team

I use the data found on this page to apply the copy command.

But I get an exception

org.postgresql.util.PSQLException: 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 8D10A2C0B9C7570E,ExtRid VTQZsFdP8DRiJPza+Ko4bc2Y91P9Wra0Qb9C Detail: ----------------------------------------------- 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 8D10A2C0B9C7570E,ExtRid VTQZsFdP8DRiJPza+Ko4bc2Y91P9Wra0Qb9C code: 8001 context: Listing bucket=awssampledb prefix=tickit/allusers_pipe.txt query: 576 location: s3_utility.cpp:525 process: padbmaster [pid=4283]

What am I doing wrong?

+6
source share
2 answers

S3 bucket and redshift must be in the same area (US East):

This example uses an Amazon S3 bucket located in the US region (Northern Virginia). When you load data using the COPY command, the bucket containing your data must be in the same region as your cluster.

If your redshift cluster is in a different region, see Step 5: Download the sample data from Amazon S3 by scrolling to the table using the area specific bucket name:

  ------------------------------ + ------------------- ------------ +
 |  Region |  region-specific-bucket-name |
 ------------------------------ + ------------------- ------------ +
 |  US East (Northern Virginia) |  awssampledb |
 ------------------------------ + ------------------- ------------ +
 |  US West (Oregon) |  awssampledbuswest2 |
 ------------------------------ + ------------------- ------------ +
 |  EU (Ireland) |  awssampledbeuwest1 |
 ------------------------------ + ------------------- ------------ +
 |  Asia Pacific (Singapore) |  awssampledbapsoutheast1 |
 ------------------------------ + ------------------- ------------ +
 |  Asia Pacific (Sydney) |  awssampledbapsoutheast2 |
 ------------------------------ + ------------------- ------------ +
 |  Asia Pacific (Tokyo) |  awssampledbapnortheast1 |
 ------------------------------ + ------------------- ------------ +
+10
source

The s3 bucket and Redshift must be in the same area. If not, the Region parameter should be specified in the copy command, then the load will work fine.

-1
source

Source: https://habr.com/ru/post/972567/

More articles:


All Articles