dbt_build.yml

# This is a basic workflow to help you get started with Actions

name: DBT Build

# Controls when the workflow will run
on:
  # Triggers the workflow on push or pull request events but only for the "main" branch
  pull_request:

  # Allows you to run this workflow manually from the Actions tab
  workflow_dispatch:

env:
  pass_prod: ${{ secrets.PASS_PROD }}
  pass_dev: ${{ secrets.PASS_DEV }}
  dbname: ${{ vars.DBNAME }}
  host: ${{ vars.HOST }}
  port: ${{ vars.PORT }}
  user_prod: ${{ vars.USER_PROD }}
  user_dev: ${{ vars.USER_DEV }}

# A workflow run is made up of one or more jobs that can run sequentially or in parallel
jobs:
  # This workflow contains a single job called "build"
  build:
    # The type of runner that the job will run on
    runs-on: [self-hosted]
    environment: dbt

    # Steps represent a sequence of tasks that will be executed as part of the job
    steps:
      # Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it
      - uses: actions/checkout@v3

      - name: Set up Python
        uses: actions/setup-python@v2
        with:
          python-version: "3.8"

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

      # Add dbt seed or other commands here if needed
      - name: Build dbt models
        run: dbt build