Query Blob Content: Query CSV Syntax

Question

I checked this API https://learn.microsoft.com/en-us/rest/api/storageservices/query-blob-contents and ran it. I was able to get complete CSV file that is stored in Azure Blob Storage.

This API also says we can request with a query

https://myaccount.blob.core.windows.net/mycontainer/myblob?comp=query

I am sending query as

<QueryRequest>
<QueryType>SQL</QueryType>
<Expression>limit 5</Expression>
</QueryRequest>

My blob is a CSV file and link mentioned above says it accepts SQL query, but I am unsure what will be used as table name or how the query will look like.

For example, if I have a csv file named custom_data.csv, suppose it has columns id, name, description, order how can I write a query saying bring me records where

1. id=123
2. name like '%john%'

if it is SQL, then what is to be added in FROM, can I get a proper example here?

Thanks.

Answer 1

Try providing complete SQL query like below. If the file is CSV, table name will be "BlobStorage"

SELECT * FROM BlobStorage LIMIT 5

See the examples here to use in Expression:

https://learn.microsoft.com/en-us/azure/storage/blobs/query-acceleration-sql-reference#select-syntax

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav