How to delete a sub folder by using adf

Question

Hi,

flowing is a path for a parquet file in a azure gen2 and the container is data:

data/hello/test/hello.parquet

I am able to use delete activity to delete the hello.parquet file but is there anyway that I can also delete the folder test.

Thanks

Answer 1

3 majors steps to follow in your case :

1. Get Metadata Activity Configuration

• Dataset: Point to your Azure Data Lake Storage Gen2 dataset
• Field list: Choose the "Child Items" property to get the list of files and subfolders in your folder

2. ForEach Activity Configuration

• Items: Use the output of the Get Metadata activity, which is a list of child items. This will typically be an expression that looks something like @activity('Get Metadata Activity Name').output.childItem

3. Delete Activity Configuration Inside ForEach

• Dataset: Same as above, but the file path should be dynamically set based on the current item in the ForEach loop. You'll likely use an expression that concatenates the folder path with the name of the current item