Hi there Maarten,
Here is more on options to load data to BigQuery: https://cloud.google.com/bigquery/docs/loading-data
Not sure but this restriction is not on driver but rather from BigQuery. Check here: https://cloud.google.com/bigquery/streaming-data-into-bigquery
A possible workaround could be to use KNIME External Tool node either to transfer your data to Google Cloud Storage using gsutil cp command and from there create a job to transfer data to BigQuery or use bq command-line tool directly to load data. Disclaimer: Haven’t tried it out so feel free to share your experience with us
Anyways, if not already, you will find out Google has quotas on everything
Br,
Ivan