I have an Athena db that I would like to duplicate (with a different name of course). Right now, I don't have an effective way to do this. My approach right now is just to execute CTAS queries per table but this obviously doesn't work for databases with 100s of tables. I've also looked into using crawlers but unfortunately, I do not always have a reliable S3 export for this.
Is there a way for me to duplicate Athena databases? Perhaps a shell script?