Hey everyone. I’m trying to set up Athena as a dataSource to load a sample from our database, but I’...

brief-helmet-79741

06/15/2023, 5:59 AM

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

06/15/2023, 6:00 AM

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

06/15/2023, 6:01 AM

Thanks in advance

fresh-football-47124

06/15/2023, 7:10 AM

sounds like a user permission error

fresh-football-47124

06/15/2023, 7:11 AM

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

brief-helmet-79741

06/15/2023, 7:23 AM

cool, will do, tanks

brief-helmet-79741

06/15/2023, 7:23 AM

thanks

brief-helmet-79741

06/15/2023, 11:35 PM

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

67 Views

Open in Slack

Previous Next

GrowthBook Users

Open source platform for stress free deployments, measured impact, and smarter decisions.