topic Re: get Metadata for Azure blob storage file and store into Lakehouse table in Data Engineering

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

PBILover — Wed, 18 Jun 2025 17:57:21 GMT

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 has only one column)

I used getMetadata and Copydata activity but still it is not working . When i do the mapping with dynamic content it looks as below

Thanks,

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

v-saisrao-msft — Thu, 19 Jun 2025 05:26:52 GMT

Hi PBILover,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Please use the set variable activity, store the metadata ( which is file name ) to a variabl and use this variable in copy data activity to insert data into a table.

Thank you.

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

PBILover — Thu, 19 Jun 2025 13:11:44 GMT

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 .

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

v-saisrao-msft — Fri, 20 Jun 2025 13:21:39 GMT

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.

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

PBILover — Fri, 20 Jun 2025 20:19:54 GMT

It works