Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This article will cover the necessary steps to connect to a Microsoft Azure Blob Storage account through the Qlik Automation interface.
Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that doesn't adhere to a particular data model or definition, such as text or binary data.
As covered in this article, Qlik Cloud Automations offer a way to manipulate files over a range of platforms, including Azure Blob Storage. In order to use the blocks with the Azure platform, we first need a connection to it.
Before that, the user who is connecting their Azure blob account needs to have a few role assignments set to themselves. An admin of the Azure workspace can provide the following mandatory permissions.
- Storage Blob Data Contributor
Admins can perform the role assignment procedure by following: Storage account > Access control IAM > Role Assignments > Add > select the above roles >add the members to whom these roles should be assigned to > Save.
When clicking the add new Azure Blob Storage connection button a pop-up like this should appear:
where a tenant id and account name must be provided. These two parameters can be easily found in the Microsoft Azure account in the following locations:
- tenant id can be found on the main overview page of your Azure Active Directory account.
- account name is actually the name given by the account administrator to the storage account
On the outline, a specific connection can only be worked with one specific storage account. Having multiple storage accounts means that the users have to connect to each storage account separately.
Working with the blob storage block would be the same as any other storage block. The main difference is that the containers have to be chosen before mentioning the path of the file. For the convenience of the user to set up their automation, a ‘do-lookup’ feature has been given to the container’s parameter. You can list out all the containers that are a part of the storage account.
And as usual, I will go over the flow of how to check for an existing blob and remove the info found in it in order to work with the blob name chosen. Always do a check for blob existence before blob creation in order to circumvent possible errors incoming from the platform.
And once you have your blob created you can add whatever information in it, but make sure that you save and close the file stream at the end of the operations:
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
