Query: List tables with retention period less than 30 days

Description

Explore which AWS Glue tables have a retention period of less than 30 days. This can be useful in identifying tables that may require a more extended retention period for data backup and disaster recovery purposes.

Query

Tables used in this query:

• aws_glue_catalog_table

SQL