sqlTransformationQuery.sql

SELECT
  *
  , cast(DATE_TRUNC('HOUR', PARSE_TIMESTAMP('%a %h %d %H:%M:%S %z %Y', i.created_at)) as string) as event_date_hour
  , PARSE_TIMESTAMP('%a %h %d %H:%M:%S %z %Y', i.created_at) as _event_time
  , cast(i.id as string) as id
FROM
  _input i
where
  i.user.id is not null
  and i.user.id is not undefined