Alerts for unused BQ tables
Upon reviewing our usage statistics, we have noticed that there are numerous tables within our BigQuery environment that have been inactive for an extended period, some dating back more than three months. These unused tables are not only occupying valuable storage space but also incurring unnecessary costs for our organization.
To address this issue proactively, we would like to explore the possibility of setting up a system where your team sends us periodic reminder emails whenever they identify tables that have been inactive for more than three months. This would enable us to review and determine whether these tables are still needed for our business operations. If not, we can take appropriate actions to archive or delete them, thus optimizing our BigQuery usage and reducing costs.