[Feature] Azure IAM/Entra ID support for Snowflake connection

### Is this your first time submitting a feature request?

- [x] I have read the [expectations for open source contributors](https://docs.getdbt.com/docs/contributing/oss-expectations)
- [x] I have searched the existing issues, and I could not find an existing issue for this feature
- [x] 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_