I am trying to load data into a Google Big Query table. I can successfully connect to my source data in a MSSQL Server and also successfully connect to my Google Big Query table. Everything runs fine until I get to the DB Loader and I get the following error Execute failed: Consumption path could not be found from Local Date Time through DATE (INT32) to DATETIME. I am knew to KNIME so any insight into this error would be helpful. thank you Dan [image]

Google Big Query loading

ipazin December 15, 2020, 11:21am 6

glad you managed to have some progress.

It does. From your error message seems you are not allowed to insert null values into TYPE_TIMESTAMP. Also keep in mind that Google BigQuery has restrictions for DML (insert, update, delete) statements. Check here more:

Br,
Ivan