Azure Blob Store File Picker

This node reads the Azure Blob Store connection and generates a pre-signed URL that references a blob. The URL is only valid for a specific period of time. Upon expiry, the URL will no longer remain active and an attempt to access the URL will generate an error. Azure Blob Store objects do not have to have their permissions set to public in order to access them. Using the generated pre-signed URL, any KNIME reader can be utilized to directly read the blob without having to fetch the blob locally first.

Options

Remote File

The blob, for which the pre-signed URL should be created.

Expiration Time

The expiration time of the generated pre-signed URL. If the selected expiration time is before the current time, then the default one hour expiration time is used.

Input Ports

Port object containing the connection information to AzureBS.

Output Ports

Variable port object containing the pre-signed URL to a blob.

Best Friends (Incoming)

• Azure Blob Store Connection (67 %) 
• Table Row To Variable Loop Start (17 %) 
• URL to File Path (8 %) Streamable
• Try (Variable Ports) (8 %) 

Best Friends (Outgoing)

• Line Reader (12 %) Deprecated
• Download (8 %) 
• URL to File Path (Variable) (8 %) 
• CSV Reader (8 %) 
• SAS7BDAT Reader (8 %) 
• URI Port to Variable (4 %) 
• Catch Errors (Var Ports) (4 %) 
• Variable to Table Row (4 %) Deprecated
• CSV Writer (4 %) Streamable
• Database Reader (legacy) (4 %) 
• File Reader (4 %) Streamable
• Table Writer (4 %) 
• String Manipulation (Variable) (4 %) 
• ORC Reader (4 %) Streamable
• SDF Reader (4 %) 
• Excel Reader (XLS) (4 %) StreamableDeprecated
• Excel Writer (XLS) (4 %) Deprecated
• File Download (4 %) 
• JSON Reader (4 %) 
• Show all 19 recommendations

Workflows

• 02_​Azure_​Blob_​Store_​Remote_​File_​Example 
• 04_​AmazonS3-MSBlobStorage_​Census_​Data 
• 02_​SQLServer_​BlobStorage_​andKNIMEModels 
• Amazon_​workflow_​9.16 
• 04_​AmazonS3-MSBlobStorage_​Census_​Data 
• 04_​AmazonS3-MSBlobStorage_​Census_​Data 
• 02_​Azure_​Blob_​Store_​Remote_​File_​Example 
• 04_​AmazonS3-MSBlobStorage_​Census_​Data 
• Show all 8 workflows

Installation

To use this node in KNIME, install KNIME Azure Cloud Connectors from the following update site:

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.