[Feature] Azure IAM/Entra ID support for Snowflake connection #1664
Description
Is this your first time submitting a feature request?
- I have read the expectations for open source contributors
- I have searched the existing issues, and I could not find an existing issue for this feature
- I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion
Describe the feature
Enable SSO authentication to Snowflake using OAuth token generated from DefaultAzureCredential.
It is especially useful when testing models locally using dbt-core. If you are logged in using azure-cli, DefaultAzureCredential can retrieve oauth token automatically.
dbt-core app deploy in AKS with workload identity can leverage this feature.
Describe alternatives you've considered
snowflake python connector also supports oauth but it's approach requires more configuration compared to using token from DefaultAzureCredential.
Who will this benefit?
Team using dbt-core app deployed in Azure Kubernetes Server
Are you interested in contributing this feature?
Yes, i have created PR #1423 for this
Anything else?
No response