integration-tests-azure.yml

name: Integration tests on Fabric DW
on:   # yamllint disable-line rule:truthy
  workflow_dispatch:
  pull_request:
    branches:
      - main

jobs:
  integration-tests-fabric-dw:
    name: Regular
    strategy:
      fail-fast: false
      max-parallel: 1
      matrix:
        profile: ["integration_tests"]
        python_version: ["3.11"]
        msodbc_version: ["18"]

    runs-on: ubuntu-latest
    permissions:
      contents: read   # Required to access repository files
      packages: read   # Grant explicit read access to packages
      id-token: write  # Needed if using OIDC authentication
    container:
      image: ghcr.io/${{ github.repository }}:CI-${{ matrix.python_version }}-msodbc${{ matrix.msodbc_version }}
    steps:
      # Azure login using federated credentials
      - name: Azure login with OIDC
        uses: azure/login@v2
        with:
          client-id: ${{ secrets.DBT_AZURE_SP_NAME }}
          tenant-id: ${{ secrets.DBT_AZURE_TENANT }}
          allow-no-subscriptions: true
          federated-token: true

      - name: Test Connection To Fabric Data Warehouse
        id: fetch_token
        run: |
          pip install azure-identity pyodbc azure-core

          python - <<EOF
          from azure.core.credentials import AccessToken
          from azure.identity import DefaultAzureCredential
          import pyodbc
          import logging
          import struct
          try:
            credential = DefaultAzureCredential()
            token = credential.get_token("https://database.windows.net/.default")
            print(f"::set-output name=access_token::{token.token}")
          except pyodbc.Error as e:
            logging.error("Error occurred while connecting to the database.", exc_info=True)
          EOF

      - uses: actions/checkout@v4

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

      - name: Run functional tests
        env:
          DBT_AZURESQL_SERVER: ${{ secrets.DBT_AZURESQL_SERVER }}
          DBT_AZURESQL_DB: ${{ secrets.DBT_AZURESQL_DB }}
          FABRIC_INTEGRATION_TESTS_TOKEN: ${{ steps.fetch_token.outputs.access_token }}
          FABRIC_TEST_DRIVER: 'ODBC Driver ${{ matrix.msodbc_version }} for SQL Server'
          DBT_TEST_USER_1: dbo
          DBT_TEST_USER_2: dbo
          DBT_TEST_USER_3: dbo
        run: pytest -ra -v tests/functional --profile "${{ matrix.profile }}"