Icon

04 Read Data from Amazon S3

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

URL: KNIME Learning Center https://www.knime.com/learning
URL: KNIME Cheat Sheet: Building a KNIME workflow for beginners https://www.knime.com/cheat-sheets/building-knime-workflow-beginners
URL: KNIME Cheat Sheet: Connectors with KNIME Analytics Platform https://www.knime.com/files/connectors-with-knime-analytics-platform.pdf
URL: KNIME Documentation: AWS Extension - User Guide https://docs.knime.com/ap/latest/aws_emr_user_guide/
URL: YouTube: Data Access with KNIME: Reading Files https://youtu.be/BtOVuF4uy_Y?si=E4WhPq5pJacO2Cfk

Authenticate your Amazon account

Step 1: Drag the "Amazon Authenticator" node into the workflow.

Step 2: Click on the node to open the configuration window. Select the "Authentication" type and enter the credentials.

Step 3: Click "Apply" and execute the node to finish the authentication.

Read data from Amazon S3 using Reader nodes

Step 1: Drag the appropriate Reader node into the workflow based on the file type.

Step 2: Click the + on the left side of the node. This will add a blue color port. Connect this port to the output of "Amazon S3 Connector" node.

Step 3: Click on the node to open the configuration window. Under "Source", specify the file path. Click the yellow folder button to browse your files. Select "Amazon s3" to access data on S3.

Connect to Amazon S3

Step 1: Drag the "Amazon S3 Connector" node into the workflow.

Step 2: Click on the node to open the configuration window. Specify the "Working directory" (click the yellow folder button to browse on S3). If you do not have browse access, manually enter the path.

Step 3:Click "Apply" and 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