Icon

04 Read Data from Amazon S3

<p><strong>Read Data from Amazon S3</strong></p><p>This workflow demonstrates how to read data files (<em>.xlsx</em>, <em>.csv</em>, <em>.txt</em>, <em>.table</em>) from Amazon S3.</p>

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: Click on the node to open Dialog box. Select the Authentication type and enter the credentials.

Step 3: Apply 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 execute the node to read the file.

Connect to Amazon S3

Step 1: Drag the "Amazon S3 Connector" node to KNIME Analytics Platform.

Step 2: 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: Execute the node.

Read Data from Amazon S3


This workflow demonstrates how to read data files (.xlsx, .csv, .txt, .table) from the Amazon S3.

Workflow complete!

Keep the momentum going by exploring Just KNIME It!on the Hub to challenge yourself and see how these nodes can be integrated into more complex workflows and use cases.

Connect toAmazon S3
Amazon S3 Connector
Read .txt file from Amazon S3
File Reader
Read .xlsx file from Amazon S3
Excel Reader
Read .csv file from Amazon S3
CSV Reader
Read KNIME table from Amazon S3
Table Reader
Authenticate toAmazon services
Amazon Authenticator

Nodes

Extensions

Links