Load fails - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Load fails

Your data load can fail for the following reasons. We suggest the following troubleshooting approaches.

Data Source is in a different Amazon Region

By default, the Amazon S3 bucket or Amazon DynamoDB table specified in the COPY command must be in the same Amazon Region as the cluster. If your data and your cluster are in different Regions, you receive an error similar to the following: 

The bucket you are attempting to access must be addressed using the specified endpoint.

If at all possible, make sure your cluster and your data source are in the same Region. You can specify a different Region by using the REGION option with the COPY command.

Note

If your cluster and your data source are in different Amazon Regions, you incur data transfer costs. You also have higher latency.

COPY command fails

Query STL_LOAD_ERRORS to discover the errors that occurred during specific loads. For more information, see STL_LOAD_ERRORS.