Querying external data in Azure Blob/Data Lake Storage

Filename and Filepath functions If you are querying multiple files or folders, you can leverage Filepath and Filename functions to get the part of the path or full path and name of the file that the row originates from: --Query all files and project file path and file name information for each row: ................
................