Hey everyone I m trying to set up Athena as a dataSource to

Question

Hey everyone I m trying to set up Athena as a dataSource to load a sample from our database but I m always getting an error from the s3 bucket when running the datasource query The error is `com amazonaws services s3 model AmazonS3Exception Access Denied Service Amazon S3 Status Code 403 Error Code AccessDenied Request ID K9RNDS0NMZHSPNGB S3 Extended Request ID QuGqM8rUg1ZGK28rP6lMPCMQ0+uXIsjcY9dhLIZzrheD5VYd9 8Fxrg9ix1yOPaFS+pais5ID0= Proxy null S3 Extended Request ID QuGqM8rUg1ZGK28rP6lMPCMQ0+uXIsjcY9dhLIZzrheD5VYd9 8Fxrg9ix1yOPaFS+pais5ID0= Path <s3 mybucket myPrefix myPartition=20230615 myfile csv> `

brief-helmet-79741 · Answer

I created the bucket with ACL access the datasource gets created but no query is allowed to run inside growthbook all queries work in Athena

brief-helmet-79741 · Answer

Thanks in advance

fresh-football-47124 · Answer

sounds like a user permission error

fresh-football-47124 · Answer

all the queries run on Athena can you double check the permissions you ve set up

brief-helmet-79741 · Answer

cool will do tanks

brief-helmet-79741 · Answer

thanks

brief-helmet-79741 · Answer

Thanks got that working by adding to my IAM user policies for QuickSightRead QuickSightFull and S3Read