Optimal join of the Knime table to the big database table by ID

Hi. Please help. I have a small table in the Knime workflow and I would like to join a big table in the Postgresql database by id.
Postgresql Connector> “DB Table Selector” is getting data from an entire table, and I’d like to optimize it to only get the ids I need. Something like:

Select * from worklfow.little_table
left join database.big_table on little_table.id = big_table.id

Hello @Iwo,

and welcome to KNIME Community!

Give Parameterized DB Query Reader node a try:

Br,
Ivan

3 Likes