Using DB Loader to Create Table in Bigquery

Jason_Kish · June 4, 2025, 7:35pm

When attempting to create a table and load data into BigQuery using the DB Loader node, the Loader node executes to 10% after which I get an error: “Execute Failed: No Filesystem for scheme “file””. On the other hand, when using the DB Writer node, my table gets created and data writes to the table, albeit extremely slowly. Any insite into what is causing this error in this node?

tobias.koetter · June 5, 2025, 2:48pm

Hello @Jason_Kish ,
what KNIME AP version and operating system are you using?
Thanks
Tobias

Jason_Kish · June 5, 2025, 3:07pm

Hi @tobias.koetter,
I’m on version 5.4.3 running Windows 10 Enterprise

tobias.koetter · June 5, 2025, 7:44pm

Hello @Jason_Kish ,
thanks for the info. I was able to reproduce the problem and will investigate further what causes it. I will get back as soon as possible.
Bye
Tobias