I am creating "Azure Data Lake Storage Gen1 for Cosmos Structured Stream" type linked service in synapse but in ARM template it is not creating parameters for all the attributes.

Sonali Dubey 0 Reputation points Microsoft Employee
2024-02-16T16:12:44.72+00:00
{
			"name": "[concat(parameters('workspaceName'), '/IDEAsGen1DataLakeConnection')]",
			"type": "Microsoft.Synapse/workspaces/linkedServices",
			"apiVersion": "2019-06-01-preview",
			"properties": {
				"annotations": [],
				"type": "AzureDataLakeStoreCosmosStructuredStream",
				"typeProperties": {
					"accountName": "accountname",
					"servicePrincipalId": "[parameters('test_properties_typeProperties_servicePrincipalId')]",
					"servicePrincipalKey": {
						"type": "AzureKeyVaultSecret",
						"store": {
							"referenceName": "KeyVaultName",
							"type": "LinkedServiceReference"
						},
						"secretName": "secret"
					},
					"tenant": "[parameters('test_properties_typeProperties_tenant')]",
					"subscriptionId": "87778789-1cc9-4b92-8ee6-f3be9080bb85",
					"resourceGroupName": "test"
				},
				"connectVia": {
					"referenceName": "AutoResolveIntegrationRuntime",
					"type": "IntegrationRuntimeReference"
				}
			},
			"dependsOn": [
				"[concat(variables('workspaceId'), '/integrationRuntimes/AutoResolveIntegrationRuntime')]",
				"[concat(variables('workspaceId'), '/linkedServices/CustomerEligibilityKeyVault')]"
			]
		}

Curretly it is creating parameters for only 2 parameter, but i want to create parameters for all attributes
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,917 questions
Microsoft Deployment Toolkit
Microsoft Deployment Toolkit
A collection of Microsoft tools and documentation for automating desktop and server deployment. Previously known as Microsoft Solution Accelerator for Business Desktop Deployment (BDD).
892 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 15,765 Reputation points Microsoft Vendor
    2024-02-19T07:10:09.4133333+00:00

    Hi @Sonali Dubey,Thank you for using Microsoft Q&A platform and thanks for your question.

    As I understand you are trying to create an "Azure Data Lake Storage Gen1 for Cosmos Structured Stream" type linked service in Synapse, but the ARM template is not creating parameters for all the attributes.

    To create parameters for all attributes, you can modify the ARM template to include parameters for all attributes. You can add the missing parameters to the "parameters" section of the template. Here is an example of how to add a parameter to the ARM template:

    "parameters": {
        "accountName": {
            "type": "string",
            "defaultValue": "accountname",
            "metadata": {
                "description": "The name of the Azure Data Lake Storage Gen1 account."
            }
        },
        "servicePrincipalId": {
            "type": "string",
            "metadata": {
                "description": "The ID of the service principal used to authenticate with Azure Data Lake Storage Gen1."
            }
        },
        "servicePrincipalKey": {
            "type": "securestring",
            "metadata": {
                "description": "The key of the service principal used to authenticate with Azure Data Lake Storage Gen1."
            }
        },
        "tenant": {
            "type": "string",
            "metadata": {
                "description": "The ID of the tenant used to authenticate with Azure Data Lake Storage Gen1."
            }
        },
        "subscriptionId": {
            "type": "string",
            "metadata": {
                "description": "The ID of the subscription containing the Azure Data Lake Storage Gen1 account."
            }
        },
        "resourceGroupName": {
            "type": "string",
            "metadata": {
                "description": "The name of the resource group containing the Azure Data Lake Storage Gen1 account."
            }
        }
    },
    

    This code will create parameters for all the attributes, including accountName , servicePrincipalId , servicePrincipalKey, tenant, subscriptionId, and resourceGroupName.

    You can then reference these parameters in your ARM template using the following syntax:

    "typeProperties": {
    
    "accountName": "[parameters('accountName')]",
    
    "servicePrincipalId": "[parameters('servicePrincipalId')]",
    
    "servicePrincipalKey": {
    
        "type": "AzureKeyVaultSecret",
    
        "store": {
    
            "referenceName": "KeyVaultName",
    
            "type": "LinkedServiceReference"
    
        },
    
        "secretName": "secret"
    
    },
    
    "tenant": "[parameters('tenant')]",
    
    "subscriptionId": "[parameters('subscriptionId')]",
    
    "resourceGroupName": "[parameters('resourceGroupName')]"
    
    }
    
    

    You can modify the values of the parameters as per your requirement. Once you have modified the ARM template, you can use it to create the "Azure Data Lake Storage Gen1 for Cosmos Structured Stream" type linked service in Synapse.

    I hope this helps. Let me know if you have any further questions or concerns.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.