Fix BigQuery destination normalization to accept any date-time format. #7776
Labels
area/connectors
Connector related issues
connectors/destination/bigquery
connectors/destinations-warehouse
A user using a Marketo to BigQuery connection is facing a bug during basic normalization (slack message here).
It appears that the Marketo connector is outputting a date-time format which is not properly handled by BigQuery leading to the following normalization error:
Invalid timestamp: '2018-09-07T17:37:18Z+0000'
.This issue is closely related to a similar normalization problem with Snowflake (#5713)
Environment
Current Behavior
Marketo source outputs date-time format such as
2018-09-07T17:37:18Z+0000
in thecreatedAt
field of the Program's stream records.Normalization fails with
Invalid timestamp: '2018-09-07T17:37:18Z+0000'
error.Expected Behavior
BigQuery normalization should handle casting this format to timestamp.
Logs
logs-18-2-marketo.txt
The text was updated successfully, but these errors were encountered: