blob Archives - GeralexGR

You can use python SDK in order to retrieve blob files from a storage account on azure. First you will need to get your connection string for the storage account from the access keys section.

Then you can execute the below python code.

	import os, uuid
	from azure.identity import DefaultAzureCredential
	from azure.storage.blob import BlobServiceClient, BlobClient, ContainerClient

	connection_string = "CONNECTION_STRING"
	service = BlobServiceClient.from_connection_string(connection_string)

	try:
	account_info = service.get_account_information()
	print('Using Storage SKU: {}'.format(account_info['sku_name']))
	container_client = service.get_container_client("files")
	try:
	for blob in container_client.list_blobs():
	print("Found blob: ", blob.name)
	except ResourceNotFoundError:
	print("Container not found.")

	except Exception as ex:
	print('Exception:')
	print(ex)

view raw azure-storage-get-blobs-python hosted with ❤ by GitHub

As seen from the screenshots, I have a container named files

And inside the container I have a test.txt file.

By running the python script (in my case I added on a container) you will get the files inside the blob container.

Quickstart: Azure Blob Storage client library for Python – Azure Storage | Microsoft Learn

Given that you have a blob storage container with multiple files, you could download the most latest one easily with az cli

In my scenario I have a container named backups which includes multiple MS SQL backups. I wanted to download the latest in order to restore through a pipeline on SQL server.

In order to accomplish that you should first login with az cli.

az login

If this is not possible through automation you would have to create a managed identity for your resource. The code is uploaded on the below gist.

	$container_name_input = "backups"
	$sg_con_string = "XXX"
	$json = az storage blob list –container-name $container_name_input –connection-string $sg_con_string \| ConvertFrom-Json \| Sort-Object -Descending { $_.properties.CreationTime } \| Select-Object name
	az storage blob download –file $json[0].name –name $json[0].name –container-name $container_name_input –connection-string $sg_con_string

view raw download-latest-blob-storage-account-az-cli hosted with ❤ by GitHub

You should replace your connection string by getting yours under access keys.

If you remove descending date the default value would be Ascending.

By executing the script you will get a json output like the below:

Tag: blob

Get blob files from azure storage account using python

Download latest file from blob storage through az cli