[Feature] Support Snowflake China host OAuth connection snowflakecomputing.cn

### 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-snowflake functionality, rather than a Big Idea better suited to a discussion

### Describe the feature

Snowflake has initiated the private preview of their product in China, with plans to transition into a public preview in June 2024. Presently, connections to Snowflake China are not possible through the standard snowflakecomputing.com host; instead, the regional host snowflakecomputing.cn must be used.

### Describe alternatives you've considered

N/A

### Who will this benefit?

dbt and snowflake users in China

### Are you interested in contributing this feature?

yes

### Anything else?

N/A