Azure Blob - Read using Python

python azure azure-storage-blobs
AngiSen picture AngiSen · Feb 20, 2018 · Viewed 29.5k times · Source

Can someone tell me if it is possible to read a csv file directly from Azure blob storage as a stream and process it using Python? I know it can be done using C#.Net (shown below) but wanted to know the equivalent library in Python to do this. 

CloudBlobClient client = storageAccount.CreateCloudBlobClient();
CloudBlobContainer container = client.GetContainerReference("outfiles");
CloudBlob blob = container.GetBlobReference("Test.csv");*

Answer

Stopped Contributing picture Stopped Contributing · Feb 20, 2018

Yes, it is certainly possible to do so. Check out Azure Storage SDK for Python

from azure.storage.blob import BlockBlobService

block_blob_service = BlockBlobService(account_name='myaccount', account_key='mykey')

block_blob_service.get_blob_to_path('mycontainer', 'myblockblob', 'out-sunset.png')

You can read the complete SDK documentation here: http://azure-storage.readthedocs.io.

Related questions

How to import Azure BlobService in python?

We are able to import azure.storage, but not access the BlobService attribute The documentation says to use the following import statement: from azure.storage import BlobService But that get's the following error: ImportError: cannot import name BlobService We tried …

Read More
How best to convert from azure blob csv format to pandas dataframe while running notebook in azure ml

I have a number of large csv (tab delimited) data stored as azure blobs, and I want to create a pandas dataframe from these. I can do this locally as follows: from azure.storage.blob import BlobService import pandas as …

Read More
Upload CSV file into Microsoft Azure storage account using python

I am trying to upload a .csv file into Microsoft Azure storage account using python. I have found C-sharp code to write a data to blob storage. But, I don't know C# language. I need to upload .csv file using …

Read More