I’m new to Knime and coming from the Alteryx world. I’m trying to use the DB Query Reader Node to extract the data on to Knime and do some transformations.
Before writing a custom SQL to extract data how can I define a Pre SQL that sets the Database role and Schema name