'AWS Glue Crawler creating temp_tables in Athena
I have a set up with a few crawlers crawling a few buckets and generating tables within Glue that are then able to be queried from the Athena query engine.
I have noticed recently that a lot of tables have been popping up, none located in the buckets I am crawling and all look like some system generated tables
temp_table_*
There appear to be over 10 created every day, and when I look at the details of them they are generated from the system query results s3://aws-athena-query-results-*
Is there a reason these are created? Do I have to manually clean them up? Is there a way to stop them being generated, or ignore them ?
They are cluttering the ability to see the tables that matter in Athena.
Thanks in advance for any assistance.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
