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

[AndrewCanva]

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-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

[jtcohen6]

Hey @AndrewCanva, thanks for opening!

Do you happen to know more details (or could link us to documentation) about Snowflake China?

dbt-snowflake connects to Snowflake using snowflake-connector-python, by passing in the account identifier. However snowflake-python-connector wants to receive region/organization/account identifiers for Snowflake China, that's how we'll want to provide it as well.

[AndrewCanva]

Hey @AndrewCanva, thanks for opening!

Do you happen to know more details (or could link us to documentation) about Snowflake China?

dbt-snowflake connects to Snowflake using snowflake-connector-python, by passing in the account identifier. However snowflake-python-connector wants to receive region/organization/account identifiers for Snowflake China, that's how we'll want to provide it as well.

@jtcohen6 the error was gone after I added host parameter in the connection profile because I used snowflake/externalbrowser authenticator, but I guess it would cause errors if oAuth authenticator method is configured re

dbt-snowflake/dbt/adapters/snowflake/connections.py

Line 57 in 5459fbf

_TOKEN_REQUEST_URL = "https://{}.snowflakecomputing.com/oauth/token-request"

[jtcohen6]

@AndrewCanva Makes sense. I'm going to keep this one on the backlog for now, and we can pick it up when someone needs it. Good to have it searchable in the meantime.

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.