Make optional parameters in csv dataset Azure Data Factory

Question

Is it possible somehow make the parameters optional?

I've tried expression but it is not working.

@if(equals(length(dataset().DirectoryName),0),null,dataset().DirectoryName)

As a workaround, I can use two datasets with a different sets of provided parameters, but I don't want to produce unnesesary simple purpose datasets.

Thank's in advance

Answer 1

Hi @Eduard Kudlaiev ,

Thank you for posting query on Microsoft Q&A Platform.

Is it possible somehow make the parameters optional?

Unfortunately, it's not possible. Once you have created parameters inside your dataset, the moment you start using that dataset you need to supply some values to it. Or else you will end up with validation errors as shown below.

Hope this will helpful. Please feel free to let us know if any further queries. Thank you.

---------------------------

Please don't forgot to click on accept it as answer button() wherever the information provided helps you. This can be beneficial to other community members as well.