Hello dpaoly,
this is unfortunately a bug in the JDBC driver from Simba that is provided by Google. The driver does not support NULL in prepared statements and this Unfortunately this bug exists already for quite some time. The DB Loader uses another API then the JDBC which is why it supports NULL values.
So the only thing I can suggest here is to ask Google support to support NULL values in the JDBC driver they provide for Big Query.
Bye
Tobias
1 Like