Using S3 bucket as source for table in Athena

Here are a few steps you can take to resolve your issue:

1. Check your S3 Bucket permissions and IAM role configurations
Ensure the bucket policy and IAM role allows the correct permissions
Documentation reference: https://docs.aws.amazon.com/athena/latest/ug/s3-permissions.html

2. Check the region for the S3 bucket and Athena
Athena can only query data if the bucket and table are in the same region