How to read contents of a CSV in Azure Blob storage using powershell

Question

Hi, Is there any way to read the contents of a file in Azure blob using Powershell?

I tried Get-AzStorageBlobContent but this stores the file in a local folder.

I don't want to store the file locally.

My requirment is to read the file from blob and then i will pipe the contents onto another step.

Is this possible please?

Thanks

Answer 1

Hi,

You can download the file contents into memory via DownloadText() method:

#Get Storage Account context
$context = New-AzStorageContext -StorageAccountName "<storage-account>" -SasToken "<sas-token>" # or -StorageAccountKey, you can use your preferred method for authentication
#Get reference for container
$container = Get-AzStorageContainer -Name "<container-name>" -Context $context
#Get reference for file
$client = $container.CloudBlobContainer.GetBlockBlobReference("<file-name>")
#Read file contents into memory
$file = $client.DownloadText()

This is possible because Get-AzStorageContainer returns an "AzureStorageContainer" object.

Azure SDK reference for the method.

BR,

Peter