In order to use the s3 copy function in redshift, the s3 bucket must be in the same region as the redshift cluster running the copy command. As written, to_redshift would only upload to the default region which for my redshift cluster was not appropriate. Boto supports region specification, this PR lets you specify the region in the to_redshift call in a boto standard way.
glamp
commented
9 years ago
In order to use the s3 copy function in redshift, the s3 bucket must be in the same region as the redshift cluster running the copy command. As written,
to_redshiftwould only upload to the default region which for my redshift cluster was not appropriate. Boto supports region specification, this PR lets you specify the region in the to_redshift call in a boto standard way.