Your gaming app, which was launched nearly three years ago, has generated extensive log data. Each day, you upload the previous day’s log files into individual Google BigQuery tables named using the format LOGS_yyyymmdd. These tables are then used to create daily and monthly analytical reports across various time ranges using table wildcard functions. Recently, you encountered an issue where queries spanning long date ranges are failing because they exceed the 1,000 table limit. What is the best way to resolve this issue?