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 are correct. It is not possible to run multiple queries in the one request.

An alternative is to create the tables in a specific database. Dropping the database will then cause all the tables to be deleted.

For example:

CREATE DATABASE foo;
CREATE EXTERNAL TABLE bar1 ...;
CREATE EXTERNAL TABLE bar2 ...;
DROP DATABASE foo CASCADE;

The DROP DATABASE command will delete the bar1 and bar2 tables.