Please use the expressions the way your Datasource would be able to parse and read the wildcard expression.
Thanks for the reply. The datasource is ADLS and the location which we are trying to access is in the form of folder structure. There are 2 folders named 'csv' and 'parquet'.
I would like to select only 'csv' folder for scanning and provided regular expression as (csv). If this text is ran on sql server, it would search for strings having csv as group.
However, providing the same text did not fetch any scan results meaning it is skipping the folder csv from scanning which should not happen as per my requirement.
From the observations, the Azure Data Lake Scanner internally uses Common File Scanner.
The Regex pattern matching is not implemented in FileScanner for file names as of now.
We have raised an enhancement request to add this feature in ADLS and File scanner. This will be added in future release
FR ID: EIC-25050