Azure databricks linked service workspaceresourceID for CICD

Satya 60 Reputation points
2023-03-14T04:05:08.9333333+00:00

I am deploying my linked service from dev to UAT and I got stuck on the below.

Can you let me know how to parameterize the workspace resource ID in Azure databricks linked service using the custom deployment template

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.
5,373 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2023-03-14T23:36:01.8066667+00:00

    Hello @Satya,

    Welcome to the MS Q&A platform.

    You can use the below custom code in your custom parameters template file

       "Microsoft.Synapse/workspaces/linkedServices": {
            "*": {
                "properties": {
                    "typeProperties": {
                        "accountName": "=",
                        "username": "=",
                        "connectionString": "|:-connectionString:secureString",
                        "secretAccessKey": "|",
    			  "domain":"=",
    			  "workspaceresourceid":"="
                    }
                }
    }
    
    

    "workspaceresourceid":"=" will paramtetrize your workspaceresourceID in your linked service connection.

    You can see the document below explaining how to use the custom parameters.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#create-custom-parameters-in-the-workspace-template

    I hope this helps.

    If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions

    0 comments No comments

0 additional answers

Sort by: Most helpful

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.