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?
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
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...