Tagban's Final Query GBQ

EXECUTE IMMEDIATE(
  SELECT string_agg(
      CONCAT("select id, firstName, otherColumns from project.database." , table_id, " ")
      , "UNION ALL \n"
   )
FROM `project.database.__TABLES__`
WHERE table_id LIKE 'LeadingTableName%' AND table_id NOT LIKE '%soupSucks'
)
This was needed because a 3rd party software we use generates a brand new table in Google Big Query everytime with the exact same schema. This allows us to join the most recent ones (ALL in the version above) and lets us have it all in one 'view' essentially thru a query.

There are likely better ways to do this, but I spent about 2 days working on this and wanted to make sure if someone else needs to JOIN DYNAMICALLY named tables in Google Big Query, they have a good starting point. Have a great 2024!