Nearly three years after the launch of your gaming app, you've been consistently uploading log files from the previous day to distinct Google BigQuery tables following the naming convention LOGS_yyyymmdd. Utilizing table wildcard functions, you've been generating daily and monthly reports spanning all timeframes. However, you've recently encountered challenges, with some queries encompassing extensive date ranges exceeding the 1,000-table limit and resulting in failures. How can you address this issue effectively?