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
Hi @naveenn08 -
I would recommend a quick glance at our documentation around DB nodes, starting here: KNIME Database Extension Guide
The first figure linked there is a typical approach for connecting to a DB, specifying a table, and then reading from that table.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.