SQL that creates or removes objects in Athena generates error "The specified key does not exist"
When using datagrip to execute an Athena SQL statement that creates or deletes a table or view, e.g. `CREATE OR REPLACE VIEW` I always get an error “The specified key does not exist. (Service: S3, Status Code: 404, Request ID: …, Extended Request ID: …)”.
The statement is executed correctly, but the error message is annoying. Is there a setting I need to change?
请先登录再写评论。
I tested table view creation in DataGrip 2026.1.3 using Athena AWS 3.5.0 JDBC driver, and I have not encountered any issues. The statements are generated correctly, and no errors are generated after executing the DDL statements or opening the objects in Database Explorer.
There's a SO thread about this error message worthwhile checking:
https://stackoverflow.com/questions/28653249/amazon-s3-exception-the-specified-key-does-not-exist
Please let me know if you need help
Logs showed driver was trying to retrieve a `4c354809-682d-4d61-8157-75faacbe369c.txt.metadata` file which does not exist for this type of query.
The fix for me was to change the advanced parameter
ResultFetcherfromautotoGetQueryResultsStream