azureazure-data-factoryazure-blob-storage

How to make sure the empty folders are also copied from source storage account to target storage account in ADF copy data activity?

Copy Data Activity - Source:

enter image description here

Copy Data Activity - Sink:

enter image description here How to make sure the empty folders are also copied from source storage account to target storage account in ADF copy data activity?

I tried keeping the '*' mark in file path type - wildcard file path but empty folders are missing in the target storage account.

Solution

  • According to this Azure blob storage doesn't support empty folders, that may be the reason for empty folders are missing in the target storage account. If you want to work with Empty folders check Enable hierarchical namespace while creating storage account as shown below:

    enter image description here

    Then the storage account behaves like ADLS gen2 account and it will support empty folders. If the target storage account is already created, then upgrade it ADLS gen2 by using option Data Lake Gen2 upgrade as shown below:

    enter image description here

    Then you will be able to copy empty folders successfully as shown below:

    enter image description here