Loading data to Big Query using Loader gives BIGQUERY_API_ERR

KNIME Analytics Platform
1

Hi Folks

Trying to get data into BQ using the dB Loader after a Create Table node.

All i get is this message, and nothing else to go by. Anyone got any clues?
Execute failed: [Simba]BigQueryJDBCDriver Error executing query job. Message: BIGQUERY_API_ERR

2

And we resolved it…
The Table we wanted to upload to, required at least one field declared via BQ Console.

3

Thanks for posting your solution Gavin!