![]() ![]() You can grant the required permission to the IAM user by attaching an IAM policy to the IAM user/role. The IAM user that runs the queries needs access to the source data bucket and the query result bucket. If you are encrypting query results with KMS key, please ensure you are allowed to access your KMS key Please ensure you are allowed to access the S3 bucket. You get an error similar to the following if you don't have access to the query result bucket: Your query has the following errors:Access denied when writing output to url: s3://my-athena-result-bucket/Unsaved/7/example_query_ID.csv. You get an error similar to the following if you don't have access to the source data bucket: Your query has the following errors:3.model.AmazonS3Exception: Access Denied (Service: Amazon S3 Status Code: 403 Error Code: AccessDenied Request ID: 72VA5FB0ASWCQFPD S3 Extended Request ID: cykX1CZ/KfxpL/h8/DOQoCBJ88qFGYqt6J52Jqh87qBfyN8c2P2azRiYjjJE1HL7i0Mg9xxxxxx= Proxy: null), S3 Extended Request ID: cykX1CZ/KfxpL/h8/DOQoCBJ88qFGYqt6J52Jqh87qBfyN8c2P2azRiYjjJE1HL7i0Mg9xxxxxx= (Path: s3://my-athena-source-bucket/athena_data.csv) Be sure that the IAM user has the required permissions to access the source data bucket and query result bucket For more information, see Troubleshooting in Athena. ![]() To troubleshoot the "Access Denied" error, confirm the following. The AWS Glue Data Catalog policy doesn't allow access to the IAM user. When attempting to compile and debug a project, Qt Creator started giving the following message :-1: error: cannot open output file debugTestFlight.You don't have access to the AWS Key Management Service (AWS KMS) key that's used to read or write the encrypted data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |