I’m building a workflow which would take a query as input from the user and execute it against a database. In the background I have a database.db file which contains the tables and necessary data. The user’s query would be executed against database.db file. I’m using “SQLite Connector” node to make the connection to the .db file and “DB Query Reader” node to execute the query.
The workflow works in the Analytics Platform but fails with an error “No such table found” as it’s not able to make connection to the .db file I presume. I can’t enter a relative path “knime://knime.workflow/…/data/database.db” in the SQLite Connector node and the local path won’t allow it to access the .db file.
Can you please how to operate with the SQLite Connector node, when using it via Web Portal and giving it a relative path to .db file