1 Reply Latest reply on Mar 21, 2017 4:58 PM by diego.medrano

    Custom SQL Date Parameter - Bigquery -FROM clause with table wildcards matches no table

    Will Bouzek

      I'm connecting Tableau to Bigquery through Custom SQL.

       

      The query runs fine when the FROM clause is formatted as below:

       

      FROM (TABLE_DATE_RANGE([xxxx.ga_sessions_], TIMESTAMP('2017-02-01'), TIMESTAMP('2017-02-01')))

       

      However I would like to replace the dates within TIMESTAMP with parameters selected by user:

       

       

      FROM (TABLE_DATE_RANGE([xxxx.ga_sessions_], TIMESTAMP(<Parameters.bigquery_start_date>), TIMESTAMP(<Parameters.bigquery_end_date>)))

       

      My parameters are set as Date > Custom Format > yyyy-mm-dd, however the query throws the error below:

       

      FROM clause with table wildcards matches no table

       

       

      Can anyone please advise?