Search code examples
azureazure-data-factory

What parameters value should I pass in Copy activity for source in Azure data factory

Whenever I am trying to preview the data it's asking for value.

I'm new to ADF.

I have provided all the parameters correctly everywhere don't know what I'm missing. It's going till the folder path correctly but not able to read files inside that folder. If I give one file name at parameter value, it's previewing the data and if I giving anything else preview data getting failed.

Attaching the steps of the pipeline and parameter declarations. enter image description here enter image description here enter image description here

Solution

  • @contains is a boolean function which will return true if the second string passed as parameter is a part of first string. In the fileName , you need to remove @contains .

    enter image description here

    If you want to use only certain file names , for example , only the file names which has '_data' as suffix (say SalesFileMay2023_data) then either use 'Filter activity' after getMetadata activity to fetch only specific filenames and pass in foreach

    Or else use 'Wildcard file path' in copy activity and provide the correct pattern.