Icon

05 Read Data from Microsoft Azure Cloud

<p><strong>Read Data: From Microsoft Azure Cloud</strong></p><p>This workflow demonstrates how to read data files (<em>.xlsx</em>, <em>.csv</em>, <em>.txt</em>, <em>.table</em>) from Microsoft Azure Cloud.</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: Microsoft Azure Extension - User Guide https://docs.knime.com/ap/latest/azure_integration_user_guide/

Connect to Azure Blob Storage

Step 1:Drag the "Azure Blob Storage 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 available files).

Step 3:Click "Apply" and execute the node.

Read data from Azure Blob Storage 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 "Azure Blob Storage 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.

Read Data: From Microsoft Azure Cloud


This workflow demonstrates how to read data files (.xlsx, .csv, .txt, .table) from Microsoft Azure Cloud.

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.

Authenticate your Microsoft account via login

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

Step 2: Click on the node to open the configuration window. Specify the "Authentication type" and enter the credentials. If "Interactive" is selected, log in via your Microsoft account.

Step 3: Under "Scopes of access", select the "Azure Blob Storage/Azure Data Lake Storage Gen2" as scope so that you can read data from Azure Blob.

Step 4: Execute the node to finish the authentication.

Provide working directory on MS Azure Blob Storage
Azure Blob Storage Connector
Read .txt file from Azure Blob
File Reader
Read .xlsx file from Azure Blob
Excel Reader
Read .csv file from Azure Blob
CSV Reader
Read KNIME table from Azure Blob
Table Reader
Authenticate toMicrosoft services
Microsoft Authenticator

Nodes

Extensions

Links