In data factory get metadata activity I dont see the option 'childItems' in fields dropdown

[prerna0708]

In data factory get metadata activity I dont see the option 'childItems' in fields dropdown, I am using MS Fabric and I am making the data factory pipeline inside Fabric, my source is a file that I put in a lakehouse inside flabric platform. Can you please tell me how to solve this? Thanks 

[v-yilong-msft]

Hi @prerna0708 ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yilong Zhou

[v-yilong-msft]

Hi @prerna0708 ,

Your solution is great, @NandanHegde.  It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

Ensure that your dataset is configured correctly. The ‘childItems’ option is typically available for datasets that point to directories, not individual files. Verify that your dataset is pointing to a folder in your Lakehouse.

If the ‘childItems’ option is still not visible, you can use a workaround by listing the files in the directory using another activity, such as Lookup or ForEach, and then processing each file individually. You can also look at this topic: How to rerun the metadata activity if no ChildItems found and usage of timeout in Azure Data Factory...

Best Regards

Yilong Zhou

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

[NandanHegde · Accepted solution]

Similar thread :

https://community.fabric.microsoft.com/t5/Data-Pipelines/data-factory-get-metadata-activity/m-p/4025...