Based on the error message, it seems like the issue is related to permissions on the S3 bucket that your query is trying to access. A few things to check:
Make sure the IAM role or user that is running the query has the necessary S3 permissions to access the objects in the S3 bucket. Specifically, it needs s3:GetObject permission on the bucket/objects.
Check if the bucket policy allows access from the account that is running the query. The bucket policy may be restricting access after some time.
Try running the query on a smaller subset of data or for a shorter time period to see if it completes successfully. This can help narrow down if it's a timeout or permission issue.
Check CloudTrail logs to see if there are any relevant ACCESS_DENIED or AUTHORIZATION_FAILURE entries for the S3 bucket around the time your query fails.
Make sure the IAM role isn't hitting some limit or quota that causes permissions to be revoked after some time.
Contact AWS Support and provide the Query ID from the error message. They may have additional insight into the issue.
In summary, focus on the S3 bucket permissions and any policies, roles, or limits that could be causing access to be denied after some time. Checking logs and contacting AWS Support can also help get to the root cause.
- How do I troubleshoot a CloudWatch Logs Insights query that shows errors or doesn't return the expected results?AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 3 days ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 8 months ago
- SUPPORT ENGINEERpublished 6 months ago
- EXPERTpublished 5 months ago