Troubleshooting S3 event integration and COPY JOB errors
Use the following information to troubleshoot common issues with Amazon S3 event integrations and COPY JOB with Amazon Redshift.
Creation of the S3 event integration failed
If the creation of the S3 event integration failed, the status of the integration is Inactive. Make sure that the following are correct for your
Amazon Redshift data warehouse.
-
You added the correct authorized principal and integration source for your target namespace in Amazon Redshift. See Prerequisites to creating an S3 event integration.
-
You added the correct resource-based policy to the source Amazon S3 bucket. See Prerequisites to creating an S3 event integration.
Your Amazon S3 data is not appearing in the target database
If data from a COPY JOB doesn't appear, check the following.
-
Query SYS_COPY_JOB_DETAIL to view if the Amazon S3 file has been loaded, whether its pending ingestion, or there is an error. For more information, see SYS_COPY_JOB_DETAIL.
-
Consult STL_ERROR or SYS_COPY_JOB_INFO if the Amazon S3 file is not there or there is unexpected wait time. Look for credential errors or anything that suggests the integration is inactive. For more information, see STL_ERROR and SYS_COPY_JOB_INFO.