Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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