CODEWITHSUNDEEP
azureazure-blob-storage
user489041
user489041

Reputation: 28312

Query blobs in Blob storage

I have serialized text data that is stored in a blob inside Azure blob storage. The text is basically key/value data. I am wondering if there is a way to easily query the blob without exploding the data into another table/database or pulling the blob into memory?

Upvotes: 2

Views: 3103

Answers (3)

boj
boj

Reputation: 11395

Update: you can use blockBlobClient.query(..) to run simple queries on JSON or CSV blob data.

Upvotes: 0

maya-msft
maya-msft

Reputation: 432

One option you could consider is to use Data Lake Analytics, as it supports Azure Blobs as data source. Depending on what your preferred way of accessing the data is, you can use PowerShell, .NET SDK etc. to query the data...

Upvotes: 0

Dean Goodman
Dean Goodman

Reputation: 983

Azure Blob storage has no API to query data within the blob - it's just dumb storage. See here for the Blob Storage API. You're essentially stuck reading, deserializing and grabbing your value(s).

Perhaps Azure table storage would be a better fit for this application? That at least keeps things in the realm of an Azure storage account rather than needing to pull in a SQL Server instance.

Upvotes: 3

Related Questions