Have seen the articles/sample workflows on creating an h2 or sqlite db to use within a workflow however i want to spin up a db directly on my knime server that i can read/write to and have it persist across jobs. currently, my h2 clears out and gets initiated for each job that is run.
is this possible? currently if i provide a path that isn’t knime://knime.workflow/database.mv.db i get errors like path cannot be resolved or a implicitly relative path cannot be used.
No idea how to provide a path that is basically the workflow group where my workflow is contained on knime server