You are responsible for managing multiple applications that generate logs which need to be analyzed using BigQuery. Each application should have its own table, and logs older than 45 days should be automatically removed to optimize storage. Following Google-recommended practices, what should you do?