Using Native with Google BigQuery

migle_purzelyte — Wed, 21 Nov 2018 17:09:09 GMT

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
;

topic Using Native with Google BigQuery in App Development