I've been trying to find out if it's possible to parameterize the linked service in an Azure Data Factory (ADF) dataset, similar to how we can parameterize the table name and schema name in a SQL Server dataset. Is there a supported way to do this?
You cannot directly parameterize the linked service inside a dataset,but we can achieve dynamic linked service selection by creating a parameterized linked service. Creating a dataset that passes parameters to that linked service.
Add the parameters as well. and test the connection.
When you create a dataset Create it using the parameterized linked service Now it will ask you to add value for server name and database name. When you assign this dataset in a pipeline activity, ADF will ask you to pass values for the linked service parameters