Invalid cast from INT64 to DATETIME with event_timestamp as datetime_key

anelendata / tap-bigquery

Singer.io tap for extracting data from BigQuery tables

Apache License 2.0

16 stars 33 forks source link

Invalid cast from INT64 to DATETIME with event_timestamp as datetime_key #17

Open dusty-campanella-maxa opened 4 years ago

dusty-campanella-maxa commented 4 years ago

Hi,

I encounter a Google API BadRequest Exception when I select the event_timestamp as the datetime_key in the tap_config.json, when running discovery command.

Screen Shot 2020-10-26 at 3 26 53 PM

Dusty

daigotanaka commented 4 years ago

I believe this the same issue as #10 It is filed as an enhancement request. The work around is to create a view in BigQuery that converts event_timestamp to datetime.

nonanerz commented 2 years ago

There is my workaround CAST(TIMESTAMP_MICROS(1664982500569) as DATETIME)