Is there a way to drop all databases in AWS athena?

Question

There's a bunch of test databases that I have and I'd like a way to drop all of them. They all have long random strings as names, so it kind of sucks to have to go through each one and delete, especially since you can't copy/paste.

score 1 · Answer 1 · answered Jul 18 '20 at 06:49

1

DROP DATABASE mydatabase CASCADE;

answered Jul 18 '20 at 06:49

bagi

627
1
8
20

score 0 · Answer 2 · edited Apr 12 '18 at 11:49

0

SHOW SCHEMAS;

Will list all databases. See: SHOW DATABASES - Amazon Athena

edited Apr 12 '18 at 11:49

John Rotenstein

241,921
22
380
470

answered Apr 12 '18 at 02:50

RaGe

22,696
11
72
104

Thanks, but is there a way to drop all of them? – Andy Apr 12 '18 at 14:15
1

well at least now you have copy paste :) – RaGe Apr 12 '18 at 14:56
hehe I suppose :) – Andy Apr 12 '18 at 16:29

score 0 · Answer 3 · answered Apr 23 '22 at 21:54

In Athena homepage, navigate to the menu on the left. Go to 'Data sources' tab. Click on the name of the Data source that contains the database you want to delete. Click on the name of the database you want to delete. Click 'Delete' button on the upper right direction. Follow the prompt.

Is there a way to drop all databases in AWS athena?

3 Answers3