Forum Discussion

PBILover's avatar
PBILover
Icon for Helper V rankHelper V
1 year ago
Solved

get Metadata for Azure blob storage file and store into Lakehouse table

Hi, I have a fabric pipeline where i want to get a content of the file and name of the file in alakehouse table. But I am not able to get the file name in a seperate column of the table . (My file h...
data engineering
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi PBILover,

    Please use the script function 
    @{concat('INSERT INTO MetaData VALUES (GETDATE(), ''', variables('Path'), ''')')}

    If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.

PBILover's avatar
PBILover
Icon for Helper V rankHelper V
1 year ago

Thanks for the reply v-saisrao-msft : I tried to get the filename in a variable, which worked fine but the mapping part is not working , when i used a mapping->add mapping and assign any dynamic content it is turning as shown in above screenshot. I dont see 2 columns .

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi PBILover,

Please use the script function 
@{concat('INSERT INTO MetaData VALUES (GETDATE(), ''', variables('Path'), ''')')}

If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

 

Thank you.