Invalid cast from INT64 to DATETIME with event_timestamp as datetime_key

[dusty-campanella-maxa]

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.

Dusty

[daigotanaka]

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]

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