is it possible to write in a csv the name of a sql table and the fields, then recover the csv file on KNIME thanks to the adequate node, and then use a node of selection of the tables which takes in parameters the value table and fields of the csv? Or is it possible to create a form to avoid manual modifications on the workflow
Certainly such a scenario is possible. I have put together two examples. In the first one there is a simple configuration file with the necessary information being read into KNIME and used as variables to do a selection
If you want to do a more interactive selection you could use Components to create an interactive experience (and later also run that on a KNIME server ).
In two steps you would first provide the user with a list of tables from your database where he might select one. You just have to apply the results of the selection and continue the workflow.
You could try this example and toy around with it.
components can at first glance seem a little scary but once you start using them you can see how fast you can build small applications without much code or no code at all. A look inside the second component:
Hey @mlauber71, i use your examples and its work perferctly, thank you so much. I have another question, is it possible to make the same workflow to configure the connection with the database, because when i try to use flow variables or component i got the same error “Errors overwriting node settings with flow variables”