Skip to content

chore(main): Release transformation-azure-compliance-free v1.2.1 (#259) #72

chore(main): Release transformation-azure-compliance-free v1.2.1 (#259)

chore(main): Release transformation-azure-compliance-free v1.2.1 (#259) #72

name: "Test Azure Compliance Policies: Postgres"
on:
pull_request:
paths:
- "transformations/azure_compliance/**"
- ".github/workflows/transformations_azure_compliance_postgres.yml"
push:
branches:
- main
paths:
- "transformations/azure_compliance/**"
- ".github/workflows/transformations_azure_compliance_postgres.yml"
jobs:
test-policies:
timeout-minutes: 30
runs-on: ubuntu-latest
defaults:
run:
working-directory: ./transformations/azure_compliance
services:
postgres:
image: postgres:11
env:
POSTGRES_PASSWORD: pass
POSTGRES_USER: postgres
POSTGRES_DB: postgres
ports:
- 5432:5432
# Set health checks to wait until postgres has started
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
steps:
- name: Checkout
uses: actions/checkout@v4
- uses: actions/setup-python@v4
with:
python-version: "3.9"
cache: "pip"
cache-dependency-path: "./transformations/azure_compliance/requirements.txt"
- name: Install dependencies
run: pip install -r requirements.txt
- name: Setup CloudQuery
uses: cloudquery/setup-cloudquery@v3
with:
version: v3.29.1
- name: Migrate DB
run: cloudquery migrate tests/azure.yml tests/pg.yml
env:
CQ_DSN: postgresql://postgres:pass@localhost:5432/postgres
- name: DBT dependencies
run: |
dbt deps --target dev-pg --profiles-dir ./tests
- name: Run Policies
run: |
dbt run --target dev-pg --profiles-dir ./tests