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><p>If you want to give your acquired knowledge a test run, take a look at the Just KNIME It challenges. (Just KNIME It Link provided in External resources section of this workflow)</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: KNIME Azure Integration User Guide https://docs.knime.com/2021-06/azure_integration_user_guide/index.html#overview
URL: New File Handling Out of Labs and Into Production https://www.knime.com/blog/new-file-handling-out-of-labs-and-into-production
URL: KNIME Cheat Sheet : Connectors with KNIME Analytics Platform https://www.knime.com/sites/default/files/2021-07/cheat-sheet-connectors.pdf
URL: Just KNIME It Challenges https://www.knime.com/just-knime-it

Authenticate your Microsoft Account via Login

Step 1: Drag the "Microsoft Authentication" node to KNIME Analytics Platform.

Step 2: Click on the node to open Dialog box. Select the Authentication mode and enter the credentials or log in via your Microsoft account. In the "Scopes of access" section, select the "Azure Blob Storage/Azure Data Lake Storage Gen2 " as scope so that you can read data from Azure Blob.

Step 3:Execute the node to finish the authentication.

Connect to Azure Blob Storage

Step 1:Drag the "Azure Blob Storage Connector" node to KNIME Analytics Platform.

Step 2: Connect the "Microsoft Authentication" node output to its input and execute the node, to get the working directory on MS Azure Blob Storage.

Read Data from Azure Blob Storage 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 blue color port to the input of the node. Connect this port to the output of "Azure Blob Storage Connector" node.

Step 3: Click on the node to open Dialog box. Select the file using the "Browse" option in "file" section. Execute the node to read the file.

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.

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

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: mpatt
Created at: 2022-04-04
On NodePit since: 2026-05-01
Last update: 2026-05-01
Created with KNIME version: v5.11.0
Tags: AzureAzure CloudMicrosoft AzureMS AzureReadMicrosoftAzure Blob Storage ConnectorBeginnerBeginner Cheat SheetBeginners Space

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!