Currently there is no way to directly set the schema. It would be nice if there were a field in the configuration node to enter the schema. Maybe in the tab "Security" next to "User" / "Password".
Otherwise it could be placed in the tab "Connection" next to "Database" or as parameter as part of the database-string, i.e. "?searchpath=<schema>" or "?currentSchema=<schema>".
This would be very helpful to avoid setting the search_path in every query node like this:
SET search_path TO {{{ msg.db2_schema }}};"msg.db2_schema" is an environment variable where i define the schema name as a workaround in my case.
Currently there is no way to directly set the schema. It would be nice if there were a field in the configuration node to enter the schema. Maybe in the tab "Security" next to "User" / "Password".
Otherwise it could be placed in the tab "Connection" next to "Database" or as parameter as part of the database-string, i.e. "?searchpath=<schema>" or "?currentSchema=<schema>".
This would be very helpful to avoid setting the search_path in every query node like this:
"msg.db2_schema" is an environment variable where i define the schema name as a workaround in my case.