Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
migle_purzelyte
Partner - Contributor II
Partner - Contributor II

Using Native with Google BigQuery

Hello,

 

I trying to connect google big query date for direct discovery but I am succeeding to convert date to year.

I am using script as follows but I am getting error I dont understand.

 

 

DIRECT QUERY
dimension 
  Date,
  NATIVE('EXTRACT(YEAR FROM Date') AS year

measure 
  Pageviews 
FROM pageviews
;

 

 

0 Replies