Combining Two Google Sheets

[A101Dal]

I've seen tutorials on combining parts of sheets and I've tried to get the Looker blend to do what I want, but it's not doing what I want.  I have the same data fields in two sheets for year 2023 and year 2024.  It's too large to combine in one Google sheet without crashing.  Is there anyway to combine them in Looker so the Looker data displays both years?

[Spreadsheep]

BigQuery is perfect for this task. You can setup each sheet as a table, then use a custom query as your data connection in Looker Studio, which will basically be something like

SELECT * FROM gsheets.table_1

UNION ALL

SELECT * FROM gsheets.table_2