How to access a file uploaded through "Local file Browser Configuration' in subsequent nodes in the workflow

KNIME Analytics Platform
1

Hi,
I am creating a custom component . In the component, I am uploading a file(python/binary etc) using "Local File Browser Configuration’ node. I can access the local path of the file in the “python script” node where I am further generating a sql query using that path and passing it to the “db sql executer”.
The sql executer fails with the error “problem accessing the external file C:/…”
Is Knime unable to access the file using the local path in the sql executer node?I am using KNIME 5.2.0.

2

Hi,
I think the problem is that the SQL is executed on the database server and the file is located in your local filesystem. You’d probably need to upload the file to the database and then run the SQL command.
Kind regards,
Alexander

1 Like
3

Thank you for the response! Understood.
Just wanted to confirm if there’s any node available for the same?

4

Hi,
You can use the SSH Connector or any other of our file system connector nodes, depending on the interfaces that the machine with the DB provides. I do not think that the DB itself provides upload functionality, so you have to go another route entirely.
Kind regards,
Alexander

5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.