Skip to content

Delete a table from Default database in Athena

0

Hi,

I was setting up Athena to view the Tardigrade alarm from S3 bucket. I used CFT to create the table. Unfortunately, it created around 86 tables (each for each files in S3) which is not expected with weird names. I tried to drop those tables but could do it. Example table name: alb_logs_288242016623_elasticloadbalancing_eu_south_2_app_tdg_66e19e9d3b92ad2d7c8c200730eb_8..._08f8e6ebc2a46b3b5bd0c0844b2756d6

Can you please let me how to delete this table? The issue is table name has (.) in it which is not recognized in the query and throws below error. line 1:105: mismatched input '.'. Expecting: <identifier>

To avoid above error tried tilt (`) but didn't work.

asked a year ago228 views

1 Answer
1
Accepted Answer

Hi,

Please check if you can delete these tables directly from Glue data catalog.

AWS Glue --> Data Catalog ---> Databases ---> Tables

Search for the table names and then select and delete the tables.

https://docs.aws.amazon.com/cli/latest/reference/glue/delete-table.html

AWS

answered a year ago

EXPERT

reviewed a year ago

  • Thank you. That works.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.