Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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