Icon

05_​Read_​Data_​from_​Amazon_​S3

Read Data from Amazon S3

This workflow demonstrates how to read data files (Text, Excel, KNIME Table and CSV) from the Amazon S3.

URL: KNIME Self Paced Course https://www.knime.com/knime-self-paced-courses
URL: KNIME Cheat Sheet : Building a KNIME Workflow for Beginners https://www.knime.com/sites/default/files/2021-07/CheatSheet_Beginner_A3.pdf
URL: Reading files in KNIME - KNIME TV - YouTube https://www.youtube.com/watch?v=IiZsOnhZgzk
URL: KNIME Amazon Web Services Integration User Guide https://docs.knime.com/2020-07/aws_emr_user_guide/index.html#_overview
URL: KNIME Cheat Sheet : Connectors with KNIME Analytics Platform https://www.knime.com/sites/default/files/2021-07/cheat-sheet-connectors.pdf

Authenticate your Amazon Account via Sign in Step 1: Drag the "Amazon Authentication" node to KNIME Analytics Platform Step 2: Double Click on the node to open Dialog box. In the "Options" tab, select the Authentication type and enter the credentials Step 3: Click on "Test connection" to Select the scope of the authentication and then Click "Ok" and execute the node to finish the authentication.
Read Data from Amazon S3 using Reader nodes Step 1: Drag the appropriate Reader node based on the file type. Step 2: Click on the 3 dots on the Reader node and select "Add File System Connection Port" option. This will add a bue color port to the input of the node. Connect this port to the output of "Amazon S3 Connector" node Step 3: Double Click on the node to open Dialog box. In the "Read from" option "Amazon S3" will be configured. Select the file using the "Browse" option in "file" section. Click "OK" and the excute the node to read the file.
Connect to Amazon S3 Step 1: Drag the "Amazon S3 Connector" node to KNIME Analytics Platform Step 2: Double Click on the node to open Dialog box. Select the "Working directory" using the "Browse" option. If you do not have Browse access on S3, manually enter the path to the workflow directory Step 3: Click "Ok" and execute the node
Connect to Amazon S3
Amazon S3 Connector
Line Reader
Authenticate your amazon account
Amazon Authenticator

Nodes

Extensions

Links