How to define a Pre/Post SQL in Knime DB Query Reader

KNIME Extensions
1

Hi All,

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

2

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.

2 Likes