azure-data-factory

Parameterizing Azure Fabric Pipelines limitations vs Azure Data Factory Pipelines

I am getting familiar with creating ETL pipelines with Azure Fabric as opposed to how I have been creating pipelines with Azure Data Factory.

I have just noticed what would appear a serious limitation with Azure Fabric pipelines and that is parameterization. I need to parameterize the connection in Azure Fabric but there doesn't to be any facility to do any parmaterization ... see examples below.

This is Azure Fabric enter image description here

Below is Azure Data Factory, you will notice the ability to parameterize virtually anything I won't including connections;

enter image description here Can someone let me know if this is by design, or is it actually possible to get the same level of parameterization with Azure Fabric pipelines as with Azure Data Factory pipelines?

I have updated the question to show what my connection and link service looks like in Azure Data Factory

enter image description here

enter image description here

Solution

  • Unfortunately, as of today that is the limitation in MSFT fabric data pipelines.

    You cannot parameterize the connection values like the database names etc.

    Also you cannot parameterize the connection to be used within your activities for non fabric components connections.

    Only Fabric component connections can be called dynamically within the activities.