Get File name from external table using polybase RRS feed

  • Question

  • Hi All

    I have some files in Data Lake storage that I want to process using SQL Data Warehouse and Polybase. Is there a way to get the name of the file associated with each row of data in the files?



    Tuesday, December 26, 2017 11:35 PM


  • Hi John, 

    unless you do some data cleansing/manipulation before loading (e.g. adding the file name as a column with values in the original files) Polybase does not offer the ability to add that information to the loads.

    But you can up-vote it here for consideration by the Product Group.


    Thomas Bragaloni

    Wednesday, December 27, 2017 9:38 AM