Athena unable to query

Question

Hi team, please i need you help. I kept getting this road block. I am trying to query a table from CURs report in an S3 bucket via athena and i got this error.
```
TABLE_NOT_FOUND: line 6:7: Table 'awsdatacatalog.athenacurcfn_kubecost_cur_report_definition.systemlake_kubecost_integration' does not exist
This query ran against the "athenacurcfn_kubecost_cur_report_definition" database, unless qualified by the query. 
```
I will appreciate a prompt answer.
many thanks

Answer

When I experienced this issue in the past, it was mostly because there weren't enough permissions like - "glue:GetDatabases","glue:GetTables","glue:GetTable", "glue:GetPartitions". It could be a permission issue.

Answer

Hello.

Does the specified table in the database "athenacurcfn_kubecost_cur_report_definition" exist?  
Is it possible that the specified database or table is incorrect?

Answer

That is currently where i got confused, apparently Athena has created and renamed the table by itself

Athena unable to query

Relevant content