Azure Data Factory Pipeline scenarios with 'scenarios to fetch metadata' scenarios When Using Parameterized Linked Service
I'm confused about I'm running into an scenario with my Azure Data Factory (ADF) pipeline where it fails with the behavior message 'Failed to fetch metadata' when trying to execute a pipeline that utilizes a parameterized linked service to connect to an Azure SQL Database. The linked service is configured to use parameters for the server name and database name, which I pass through from the pipeline parameters. I have ensured that the parameters are correctly set and I'm using the correct data types. Here's how my linked service configuration looks: ```json { "name": "AzureSqlDatabaseLinkedService", "type": "AzureSqlDatabase", "typeProperties": { "connectionString": "Server={serverName};Database={databaseName};An Integrated Security=True;" }, "parameters": { "serverName": { "type": "string" }, "databaseName": { "type": "string" } } } ``` In my pipeline, I'm passing the parameters like this: ```json { "name": "MyPipeline", "properties": { "activities": [ { "name": "CopyData", "type": "Copy", "inputs": [ {"referenceName": "InputDataset", "type": "DatasetReference"} ], "outputs": [ {"referenceName": "OutputDataset", "type": "DatasetReference"} ], "source": { "type": "SqlSource" }, "sink": { "type": "BlobSink" }, "linkedServiceName": { "referenceName": "AzureSqlDatabaseLinkedService", "type": "LinkedServiceReference", "parameters": { "serverName": "<your_server_name>", "databaseName": "<your_database_name>" } } } ] } } ``` I've double-checked the parameter values that are being passed at runtime, and they seem to be correct. I can connect to the database manually using the same credentials in SQL Management Studio without any issues. However, when I run the pipeline, it fails at the Copy activity with the behavior message: ``` Failed to fetch metadata from the linked service 'AzureSqlDatabaseLinkedService'. ``` I've also looked into using 'Debug Mode' to see if any additional details are provided, but it just reiterates the same behavior without any additional context. Any ideas on what might be causing this scenario? Are there any best practices for setting up parameterized linked services that I might be missing? I'm working on a CLI tool that needs to handle this. I'd love to hear your thoughts on this.