I have created 3 Google Cloud bigQuery tables mapping to 3 worksheets in a single Google Sheets sheet. I have named the 3 tables according to the 3 worksheet names, and I can run SQL queries against the tables.
My problem is that the results from the query always show the records in the first worksheet within the spreadsheet, not the second or third worksheet.
Is it possible to associate BigQuery tables to different worksheets of the same Google Sheets document? If not, is the only solution to have 3 separate sheet documents each with the first worksheet being the one with the records that BigQuery will query?
