Permission problem in Cloudformation
Cloudformation create-stack generates an Athena access denied while writing error. The problem is generated when writing to the athena-results bucket. I'm logged in with a SSO role with AdministratorAccess access via CLI.
I can create the specified object from the command line via "aws s3 cp" and I'm able to execute "aws athena start-query-execution" without trouble. It's only via cloudformation.
Bellow the specific error: ResourceStatus: CREATE_FAILED ResourceStatusReason: 'Resource handler returned message: "[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Access denied when writing to location: s3://cost-athena-results-123456789012/8fefd451-2a3f-4bc9-881e-84061de8db91.csv [Execution ID: 8fefd451-2a3f-4bc9-881e-84061de8db91]" (RequestToken: b0d4b7d5-998b-6ca8-22c6-657fa2433fe8, HandlerErrorCode: null)' ResourceType: AWS::QuickSight::DataSource
If you are trying to connect to Athena from QuickSight, you also need to authorize QuickSight to access S3: https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-connect-S3.html
Cloudformation => Creating Authorizer to a ApiGateaway with Cloudformation => Error with JWTConfiguration when creating the authorizerAccepted Answerasked 2 months ago
Athena Error: Permission Denied on S3 Path.Accepted Answerasked 2 months ago
Shouldn't the AWSReadOnlyAccess permission group allow access to query Athena tablesasked 7 days ago
PROBLEM Cloudformation Stuckasked 3 years ago
Access Denied Error in Athena query fileasked 3 months ago
specifying a list of values when deploying to aws cloudformation using github actionsasked 3 months ago
Sagemake couldn't access S3 vis athena queryasked 3 months ago
Permission problem in Cloudformationasked 2 months ago
Unable to set bucket accelerate configuration - Administrator Accessasked 3 months ago
Is there any limit to the number or age of events logged in CloudFormation event history?Accepted Answerasked 8 months ago