How to delete / drop multiple tables in AWS athena?

Question

I am trying to drop few tables from Athena and I cannot run multiple DROP queries at same time. Is there a way to do it?

Thanks!

Answer 1

You can use aws-cli batch-delete-table to delete multiple table at once.

aws glue batch-delete-table \
--database-name <database-name> \
--tables-to-delete "<table1-name>" "<table2-name>" "<table3-name>" ...