Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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