动态更改 Azure 数据工厂中表存储或 Blob 存储的连接字符串。目前，我可以看到数据库相关数据集的此类选项吗？如何在表或 Blob 存储中实现相同的效果
我相信这就是你想要的。https://learn.microsoft.com/en-us/azure/data-factory/parameterize-linked-services https://learn.microsoft.com/en-us/azure/data-factory/parameterize-linked-services正如文档提到的，UI 仅支持 8 个链接服务。对于其他人，您可以按照相同的模式直接更改 json 代码。
{
"name": "AzureBlobStorage12",
"type": "Microsoft.DataFactory/factories/linkedservices",
"properties": {
"parameters": {
"accountName": {
"type": "String"
},
"accountKey": {
"type": "String"
}
},
"annotations": [],
"type": "AzureBlobStorage",
"typeProperties": {
"connectionString": "DefaultEndpointsProtocol=https;AccountName=@{linkedService().accountName};AccountKey=@{linkedService().accountKey};EndpointSuffix=core.windows.net;"
}
}
}
You can't put the entire connection string as an expression. You need parameterize every part separately. Make sure you noticed the prameters field.
And then every time you use the linked service, you will be able to pass different values to it.