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
I am sending query as
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
- name like '%john%'
if it is SQL, then what is to be added in FROM, can I get a proper example here?