Hey everyone. I’m trying to set up Athena as a dat...
# ask-questions
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>)
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
Thanks in advance
sounds like a user permission error
all the queries run on Athena, can you double check the permissions you’ve set up?
cool, will do, tanks
Thanks - got that working by adding to my IAM user policies for QuickSightRead, QuickSightFull and S3Read