WARNING - Version 1.74.1 BigQuery Data Type Issues

Matillion ETL
1

Once I upgraded to Version 1.74.1 on BigQuery, I experienced issues with BigQuery data types. The Salesforce incremental loader is appending data that does not match the UI. This seems to be happening with timestamp and date fields. Random rows with data in the Salesforce UI are added to BigQuery as NULL values.

 

This also happens with the Customer API Query and other tables I upload. It seems to be affecting multiple BigQuery connectors. Matillion Support has acknowledged that this is an issue, but I wanted to warn others of the problem.

 

Is anyone else experiencing this issue?

2

Hi @christian1587613683335​ , I'm sorry to hear that you're experiencing an issue and thank you for raising it with the support team, I'm glad to hear they are on the case! If there's anything we can do for you in the meantime, please let us know.

Many thanks,

Claire