I want to get session from Google Analytic and display them in Tableau. Attached is my Standard SQL queries:
with subQ_googleanalytic as(
select parse_date("%Y%m%d",date) as GA_date
,COUNT(DISTINCT CONCAT(CAST(fullvisitorid AS string),CAST(visitid AS string))) AS no_sessions
, unnest(hits) as hits
where _TABLE_SUFFIX between
FORMAT_DATE("%Y%m%d", DATE_SUB(CURRENT_DATE(), INTERVAL 2 DAY)) AND
FORMAT_DATE("%Y%m%d", DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY))
and totals.visits = 1 --The value is null if there are no interaction events in the session.
and hits.page.hostname is null
group by 1)
The query run successfully in Bigquery. However, i cannot paste the query into my Tableau. Tableau said:
An error occurred while communicating with the data source.
The Google BigQuery service was unable to compile the query.
Syntax error: Expected ")" but got end of statement at [1:643]
I am using tableau desktop 2018.2. How do i resolve this?
Message was edited by: Pitchstar Chernenko - Fix the title