Data-and-AI-Platform/.github/workflows/cd_synapse_workspace.yml at main · microsoft/Data-and-AI-Platform · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
# This is a basic workflow to help you get started with Actions

name: cd-synapse

# Controls when the workflow will run
on:
  # Workflow executes when new commit happens on main within data factory publish folder
  #push:
  #  branches:
  #    - 'adf_publish'

  # Allows you to run this workflow manually from the Actions tab
  workflow_dispatch:
    inputs:
      DeploymemtEnvironments:
        description: 'Deploy To Which Environments'
        required: true
        type: choice
        options:
          - test
          - prod
          - test and prod
      PublishBranchName:
        description: 'Synapse Publish Branch Name'
        required: true
        type: choice
        options:
          - UpdateOptionsWithCorrectBranchName

# A workflow run is made up of one or more jobs that can run sequentially or in parallel
jobs:

  deploy-to-test-synpase:
    if: ${{ inputs.DeploymemtEnvironments == 'test' || inputs.DeploymemtEnvironments == 'test and prod' || inputs.DeploymemtEnvironments == '' }}

    # The type of runner that the job will run on
    runs-on: ubuntu-22.04

    environment:
      name: test

    steps:
      # Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it
      - uses: actions/checkout@v3
        with:
          ref: ${{ inputs.PublishBranchName }}

      - name: Get Variables
        run: |
          $json_data = Get-Content "./DeploymentComponents/variables/general_variables/variables_dev.json" | ConvertFrom-Json

          # dev data factory name
          $synapseWorkspaceNameDev = $json_data.synapseWorkspaceName
          "synapseWorkspaceNameDev=$synapseWorkspaceNameDev" >> $env:GITHUB_ENV

          $json_data = Get-Content "./DeploymentComponents/variables/general_variables/variables_test.json" | ConvertFrom-Json -AsHashtable
          foreach ( $item in $json_data.GetEnumerator() )
          {
            if($($item.Value).GetType().Name.ToUpper().Contains("HASHTABLE") -or $($item.Value).GetType().Name.ToUpper().Contains("OBJECT[]")){
              $value = $($item.Value) | ConvertTo-Json -Compress
              "$($item.Name)=$value" >> $env:GITHUB_ENV
            } else {
              "$($item.Name)=$($item.Value)" >> $env:GITHUB_ENV
            }
          }
        shell: pwsh

      - name: Deploy to Synapse Workspace
        uses: azure/synapse-workspace-deployment@V1.8.0
        with:
          environment: 'Azure Public'
          TargetWorkspaceName: ${{ env.synapseWorkspaceName }}
          resourceGroup: ${{ env.PrimaryRgName }}
          TemplateFile: ./${{ env.synapseWorkspaceNameDev }}/TemplateForWorkspace.json
          ParametersFile: ./${{ env.synapseWorkspaceNameDev }}/TemplateParametersForWorkspace.json
          OverrideArmParameters: ./${{ env.synapseWorkspaceName }}/OverrideArmParameters.yaml
          clientId: ${{ secrets.SERVICE_PRINCIPAL_CLIENT_ID }}
          clientSecret: ${{ secrets.SERVICE_PRINCIPAL_SECRET }}
          subscriptionId: ${{ secrets.SUBSCRIPTION_ID }}
          tenantId: ${{ secrets.TENANT_ID }}
          DeleteArtifactsNotInTemplate: 'true'
          managedIdentity: 'false'
          deployManagedPrivateEndpoint: 'false'
          FailOnMissingOverrides: 'true'
          operation: 'validateDeploy'

  deploy-to-prod-synapse:
    if: ${{ inputs.DeploymemtEnvironments == 'prod' || inputs.DeploymemtEnvironments == 'test and prod' || inputs.DeploymemtEnvironments == '' }}

    # The type of runner that the job will run on
    runs-on: ubuntu-22.04

    environment:
      name: production

    steps:
      # Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it
      - uses: actions/checkout@v3
        with:
          ref: ${{ inputs.PublishBranchName }}

      - name: Get Variables
        run: |
          $json_data = Get-Content "./DeploymentComponents/variables/general_variables/variables_dev.json" | ConvertFrom-Json

          # dev data factory name
          $synapseWorkspaceNameDev = $json_data.synapseWorkspaceName
          "synapseWorkspaceNameDev=$synapseWorkspaceNameDev" >> $env:GITHUB_ENV

          $json_data = Get-Content "./DeploymentComponents/variables/general_variables/variables_prod.json" | ConvertFrom-Json -AsHashtable
          foreach ( $item in $json_data.GetEnumerator() )
          {
            if($($item.Value).GetType().Name.ToUpper().Contains("HASHTABLE") -or $($item.Value).GetType().Name.ToUpper().Contains("OBJECT[]")){
              $value = $($item.Value) | ConvertTo-Json -Compress
              "$($item.Name)=$value" >> $env:GITHUB_ENV
            } else {
              "$($item.Name)=$($item.Value)" >> $env:GITHUB_ENV
            }
          }
        shell: pwsh

      - name: Deploy to Synapse Workspace
        uses: azure/synapse-workspace-deployment@V1.8.0
        with:
          environment: 'Azure Public'
          TargetWorkspaceName: ${{ env.synapseWorkspaceName }}
          resourceGroup: ${{ env.PrimaryRgName }}
          TemplateFile: ./${{ env.synapseWorkspaceNameDev }}/TemplateForWorkspace.json
          ParametersFile: ./${{ env.synapseWorkspaceNameDev }}/TemplateParametersForWorkspace.json
          OverrideArmParameters: ./${{ env.synapseWorkspaceName }}/OverrideArmParameters.yaml
          clientId: ${{ secrets.SERVICE_PRINCIPAL_CLIENT_ID }}
          clientSecret: ${{ secrets.SERVICE_PRINCIPAL_SECRET }}
          subscriptionId: ${{ secrets.SUBSCRIPTION_ID }}
          tenantId: ${{ secrets.TENANT_ID }}
          DeleteArtifactsNotInTemplate: 'true'
          managedIdentity: 'false'
          deployManagedPrivateEndpoint: 'false'
          FailOnMissingOverrides: 'true'
          operation: 'validateDeploy'