Server-side Queries for AzureBlobStorage

Server-side queries for AzureBlobStorage use SQL syntax to specify the row filter predicates and column projections.

In the SQL query, the keyword BlobStorage represents the file that is being queried, for example:

Copy

SELECT * FROM BlobStorage

Column references are specified as _N where the first column is _1. If the source file contains a header row and it is enabled in the File connection, then the column can be referred to by the name that is specified in the header row. In this case, both column references and column names can be used in a query, for example:

Copy

SELECT _1 AS ID, Title, _3, _4, _5, _6, _7, _8, _9, _10 FROM BlobStorage

It is possible to filter and limit the number of rows for a SQL query, for example:

Copy

SELECT * FROM BlobStorage WHERE Region IN ('East', 'West') AND CompanyName LIKE 'Bike%' OR Country = 'Germany' LIMIT 10

Note: The maximum number of columns that can be specified in the SELECT statement is limited to 49. If more than 49 columns are needed in the result, then the wildcard character * (SELECT * FROM BlobStorage) has to be used.

Such SQL clauses like ORDER BY, GROUP BY, DISTINCT, HAVING, IS NULL, and IS NOT NULL do not work for server-side queries.

For more information, please refer to Microsoft Documentation.

Updated April 14, 2025