Using a wildcard in a get metadata activity to consider a specific set of files

[pmscorca]

Hi,

in a get metadata activity of a data pipeline I've tried to use a wildcard as "*.csv" in the file name cell of the file path section, but so the get metadata activity searchs a *.csv file.

It seems that it isn't possible to use an handy wildcard in a get metadata activity?

Any suggests in order to consider a specific set of files? Thanks

[Anonymous]

Hi @pmscorca ,

As @NandanHegde said, the Get Metadata activity does not support wildcard filters on folders/files.

related document:

Get Metadata activity - Azure Data Factory & Azure Synapse | Microsoft Learn

Consider dynamically constructing file paths or names using expressions and variables in the pipeline.

related document:

Parameterize linked services - Azure Data Factory & Azure Synapse | Microsoft Learn

Best Regards,
Adamk Kong

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

[NandanHegde · Accepted solution]

wildcard is not supported in Get metadata activity

So you would have to use a combination of Get meta data activity and filter activity.

get all files present within the folder via Get meta data activity and then leveraging the filter activity, filter out CSV specific file extensions