Load Data from Amazon Redshift Connector

[Knime1]

Dear all,

I am fairly new to the community. I just wanted to ask how I can read data from Amazon Redshift into csv-files for example. My connection and credentials on the Amazon Redshift Connector was already successfull.

Thanks in advance

[AlexanderFillbrunn]

Hi @Knime1,
Welcome to the forum. If your Redshift Connector is already green, you are almost there. Now you can use:

• A DB Table Selector to choose the table to read
• DB Row Filter, DB Column Filter, and other DB nodes to adjust the query to only read what you need
• A DB Reader to load the data from the database
• A CSV Writer to write the data into a CSV file.

I hope this helps!
Kind regards,
Alexander

[Knime1]

Thank you very much, this worked out pretty good