Lists the contents of the supplied path.

Table Specific Information

Select

This will return a list of all the files and directories in your system. By default, all the files and folders of the first level will be retrieved. You can configure the 本製品 to read all files and folders recursively by setting the IncludeSubDirectories property to true. All filters are executed client-side within the 本製品.

A simple query such as SELECT * FROM Resources will have different results with different combinations of IncludeSubDirectories and Directory connection properties.

• If IncludeSubDirectories=true and Directory is not set the table will return all files and folder with its subfolders in all the storage.
• If IncludeSubDirectories=true and Directory=path the table will return all files and folders with its subfolders in the path specified in Directory.
• If IncludeSubDirectories=false and Directory is not set the table will return all files and folders of the root folder.
• If IncludeSubDirectories=false and Directory=path the table will return all files and folders of the folder specified in path.

You can alternatively specify the Directory column in the WHERE clause conditions to list the files in a specific directory.

For example, the below query will list the files located in the first level of the 'SecondLevelDir1' directory.

SELECT * FROM Resources WHERE Directory='FirstLevelDir/SecondLevelDir1'

You can also make use of the IN operator, in order to list the files located in the first levels of multiple specified directories.

SELECT * FROM Resources WHERE Directory IN ('FirstLevelDir', 'FirstLevelDir/SecondLevelDir1', 'FirstLevelDir/SecondLevelDir2')

Note: The 本製品 will use the Azure Data Lake Storage API to process WHERE clause conditions built with the following Directory column, and the '=' operator. The rest of the filter is executed client side within the 本製品.

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。