Hey everyone. I’m trying to set up Athena as a dat...
# ask-questionsb
brief-helmet-79741
06/15/2023, 5:59 AMHey 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 AMI 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 AMThanks in advance
f
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?
b
brief-helmet-79741
06/15/2023, 7:23 AMcool, will do, tanks
brief-helmet-79741
06/15/2023, 7:23 AMthanks
brief-helmet-79741
06/15/2023, 11:35 PMThanks - got that working by adding to my IAM user policies for QuickSightRead, QuickSightFull and S3Read
68 Views