postgresql - Copying data from S3 to Redshift -


i feel should lot easier it's been on me.

copy table 's3://s3-us-west-1.amazonaws.com/bucketname/filename.csv' credentials 'aws_access_key_id=my-access;aws_secret_access_key=my-secret' region 'us-west-1'; 

note added region section after having problem did nothing.

where confused though in bucket properties there https://path/to/the/file.csv. can assume documentation have read calling path start s3://... change https s3 shown in example.

however error:

"error : error:  s3serviceexception: bucket attempting access must addressed using specified endpoint.  please send future requests endpoint.,status 301,error permanentredirect,rid" 

i using navicat postgresql connect redshift , im running on mac.

the s3 path should 's3://bucketname/filename.csv'. try this.


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -