v1.8.9

Workflow Configuration Updates:

• .github/workflows/integration-tests-azure.yml: Renamed the job and updated the profile and permissions for integration tests. Switched from Azure CLI login to Azure login with OIDC and added a step to test the connection to Fabric Data Warehouse. [1] [2]
• .github/workflows/publish-docker.yml: Added workflow_dispatch trigger and a step to list Docker images. [1] [2]
• .github/workflows/unit-tests.yml: Limited Python versions to 3.10 and 3.11 for unit tests.

Codebase Enhancements:

• dbt/adapters/fabric/fabric_connection_manager.py: Added methods for handling access tokens and updated the connection string logic to include pooling and retry configurations. [1] [2] [3] [4] [5] [6]
• dbt/adapters/fabric/__version__.py: Bumped version to 1.8.9.
• dbt/adapters/fabric/fabric_credentials.py: Added access_token attribute and updated default retry count.

Macro Improvements:

• dbt/include/fabric/macros/adapters/catalog.sql: Added database usage checks and improved join conditions. [1] [2] [3] [4] [5]
• dbt/include/fabric/macros/adapters/metadata.sql: Ensured database names are properly formatted.
• dbt/include/fabric/macros/adapters/schema.sql: Added database usage commands before dropping schemas.
• dbt/include/fabric/macros/adapters/show.sql: Improved SQL limit handling logic.
• dbt/include/fabric/macros/materializations/models/table/table.sql: Enhanced logic for creating backup relations.
• dbt/include/fabric/macros/materializations/snapshots/helpers.sql: Simplified column creation logic.
• dbt/include/fabric/macros/materializations/snapshots/snapshot.sql: Improved handling of temporary views in snapshots.

These changes collectively enhance the integration testing setup, streamline connection management, and improve the reliability and clarity of macro definitions.

Full Changelog: v1.8.8...v1.8.9