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 Mar 14, 2017 5:46 PM

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?

1. Re: Custom SQL Date Parameter - Bigquery -FROM clause with table wildcards matches no table

diego.medrano Mar 21, 2017 4:58 PM (in response to Will Bouzek)

Hey Will,

The error doesn't seem to be coming from our end. Does this thread help?

FROM clause with table wildcards matches no table · Issue #117 · igrigorik/githubarchive.org · GitHub

-Diego
Like Show 0 Likes(0)

Actions

Tableau Community