1 Reply Latest reply on Jan 3, 2014 1:11 PM by Robert Morton

    Dynamic Custom SQL for Multiple BigQuery Tables

    Kyle Campbell

      Hi Everyone,

      I have a BigQuery database where daily data is uploaded into it's own table. So I have tables named "20131201", "20131202", etc. I can write a fixed Custom SQL to "merge" those tables into a single Tableau data connection by doing:


      SELECT * FROM db.20131201, db.20131202

       

      I'd like to have a single query that does not require me to update the Custom SQL everytime a new table is added. Something like:

       

      SELECT * FROM db.*

       

      Which doesn't work. I would like to avoid making one giant table on Big Query's side. Any suggestions?