3 Replies Latest reply on Mar 19, 2014 8:49 PM by Rishi Sharma

    Stacking BigQuery tables

    Felix Dannegger

      Hi,

      in BigQuery, I have identically structured tables for different time periods (one table for each month). Now in Tableau, I would like to set up a "live feed" to BigQuery of a year's worth of data.

      I guess that would mean figuring out the correct Custom SQL statement to use in the BigQuery connector. In BigQuery SQL I would simply use something like SELECT * from JAN, FEB, MAR, APR, MAY .... (with JAN, FEB being the names of the tables for each month). Unfortunately I can't get this to work through the Tableau connector. Am I missing something or do I need to use a series of UNION ALL statements?

       

      BTW, I can live feed to a single month table using the connector without any issues.

       

      Any help would be greatly appreciated.

      Thank you

      Felix