dbt-analytics-engineering/.github/workflows/dbt-cd.yml at main · Ritik574-coder/dbt-analytics-engineering · 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
name: dbt CD

on:
  workflow_dispatch:
    inputs:
      target:
        description: dbt target (dev or prod)
        required: true
        default: prod
        type: choice
        options:
          - dev
          - prod
  push:
    branches: [main]
    paths:
      - "models/**"
      - "macros/**"
      - "seeds/**"
      - "snapshots/**"
      - "dbt_project.yml"
      - "packages.yml"

concurrency:
  group: dbt-cd-${{ github.ref }}
  cancel-in-progress: false

env:
  PYTHON_VERSION: "3.11"

jobs:
  deploy:
    name: Deploy (${{ github.event_name == 'workflow_dispatch' && inputs.target || 'prod' }})
    runs-on: ubuntu-latest
    environment: production
    steps:
      - name: Checkout
        uses: actions/checkout@v4

      - name: Set up Python
        uses: actions/setup-python@v5
        with:
          python-version: ${{ env.PYTHON_VERSION }}
          cache: pip
          cache-dependency-path: requirements.txt

      - name: Install ODBC Driver 18
        run: |
          curl -fsSL https://packages.microsoft.com/keys/microsoft.asc \
          | sudo gpg --dearmor --batch --yes \
          -o /usr/share/keyrings/microsoft-prod.gpg

          echo "deb [arch=amd64 signed-by=/usr/share/keyrings/microsoft-prod.gpg] https://packages.microsoft.com/ubuntu/22.04/prod jammy main" \
          | sudo tee /etc/apt/sources.list.d/microsoft-prod.list

          sudo apt-get update
          sudo ACCEPT_EULA=Y apt-get install -y msodbcsql18 unixodbc-dev

      - name: Install dependencies
        run: pip install -r requirements.txt

      - name: Configure dbt profile
        env:
          DBT_PROFILES_DIR: ${{ runner.temp }}/dbt-profiles
          DBT_SQLSERVER_HOST: ${{ secrets.DBT_SQLSERVER_HOST }}
          DBT_SQLSERVER_PORT: ${{ secrets.DBT_SQLSERVER_PORT }}
          DBT_SQLSERVER_DATABASE: ${{ secrets.DBT_SQLSERVER_DATABASE }}
          DBT_SQLSERVER_SCHEMA: ${{ secrets.DBT_SQLSERVER_SCHEMA }}
          DBT_SQLSERVER_USER: ${{ secrets.DBT_SQLSERVER_USER }}
          DBT_SQLSERVER_PASSWORD: ${{ secrets.DBT_SQLSERVER_PASSWORD }}
        run: |
          mkdir -p "$DBT_PROFILES_DIR"
          cp profiles.example.yml "$DBT_PROFILES_DIR/profiles.yml"
          echo "DBT_PROFILES_DIR=$DBT_PROFILES_DIR" >> "$GITHUB_ENV"

      - name: Resolve dbt target
        run: |
          if [ "${{ github.event_name }}" = "workflow_dispatch" ]; then
            echo "DBT_TARGET=${{ inputs.target }}" >> "$GITHUB_ENV"
          else
            echo "DBT_TARGET=prod" >> "$GITHUB_ENV"
          fi

#      - name: dbt deps
#        env:
#          DBT_SQLSERVER_HOST: ${{ secrets.DBT_SQLSERVER_HOST }}
#          DBT_SQLSERVER_PORT: ${{ secrets.DBT_SQLSERVER_PORT }}
#          DBT_SQLSERVER_DATABASE: ${{ secrets.DBT_SQLSERVER_DATABASE }}
#          DBT_SQLSERVER_SCHEMA: ${{ secrets.DBT_SQLSERVER_SCHEMA }}
#          DBT_SQLSERVER_USER: ${{ secrets.DBT_SQLSERVER_USER }}
#          DBT_SQLSERVER_PASSWORD: ${{ secrets.DBT_SQLSERVER_PASSWORD }}
#        run: dbt deps
#
#      - name: dbt debug
#        env:
#          DBT_SQLSERVER_HOST: ${{ secrets.DBT_SQLSERVER_HOST }}
#          DBT_SQLSERVER_PORT: ${{ secrets.DBT_SQLSERVER_PORT }}
#          DBT_SQLSERVER_DATABASE: ${{ secrets.DBT_SQLSERVER_DATABASE }}
#          DBT_SQLSERVER_SCHEMA: ${{ secrets.DBT_SQLSERVER_SCHEMA }}
#          DBT_SQLSERVER_USER: ${{ secrets.DBT_SQLSERVER_USER }}
#          DBT_SQLSERVER_PASSWORD: ${{ secrets.DBT_SQLSERVER_PASSWORD }}
#        run: dbt debug --target "$DBT_TARGET"
#
#      - name: dbt run
#        env:
#          DBT_SQLSERVER_HOST: ${{ secrets.DBT_SQLSERVER_HOST }}
#          DBT_SQLSERVER_PORT: ${{ secrets.DBT_SQLSERVER_PORT }}
#          DBT_SQLSERVER_DATABASE: ${{ secrets.DBT_SQLSERVER_DATABASE }}
#          DBT_SQLSERVER_SCHEMA: ${{ secrets.DBT_SQLSERVER_SCHEMA }}
#          DBT_SQLSERVER_USER: ${{ secrets.DBT_SQLSERVER_USER }}
#          DBT_SQLSERVER_PASSWORD: ${{ secrets.DBT_SQLSERVER_PASSWORD }}
#        run: dbt run --target "$DBT_TARGET"
#
#      - name: dbt test
#        env:
#          DBT_SQLSERVER_HOST: ${{ secrets.DBT_SQLSERVER_HOST }}
#          DBT_SQLSERVER_PORT: ${{ secrets.DBT_SQLSERVER_PORT }}
#          DBT_SQLSERVER_DATABASE: ${{ secrets.DBT_SQLSERVER_DATABASE }}
#          DBT_SQLSERVER_SCHEMA: ${{ secrets.DBT_SQLSERVER_SCHEMA }}
#          DBT_SQLSERVER_USER: ${{ secrets.DBT_SQLSERVER_USER }}
#          DBT_SQLSERVER_PASSWORD: ${{ secrets.DBT_SQLSERVER_PASSWORD }}
#        run: dbt test --target "$DBT_TARGET"
#