Snowflake Integration URL issue

KNIME Extensions
,
1

Dear community,

I installed KNIME Snowflake Integration(5.3.0) and try to connect my Snowflake account(China tenent), then I got error message like below. My snowflake account url should be snowflakecomputing.cn rather than snowflakecomputing.com.

Would anyone kindly advise?

ERROR Snowflake Connector 3:1 Execute failed: JDBC driver encountered communication error. Message: Certificate for <mylocator.cn-northwest-1.aws.snowflakecomputing.com> doesn’t match any of the subject alternative names: [*.prod3.us-west-2.snowflakecomputing.com, *.us-west-2.snowflakecomputing.com, *.global.snowflakecomputing.com, *.snowflakecomputing.com, *.prod3.us-west-2.aws.snowflakecomputing.com].

Snowflake Integration Version details:
KNIME Snowflake Integration 5.3.0.v202406131517 org.knime.features.snowflake.feature.group KNIME AG, Zurich, Switzerland

2

Hello @Rock,

Thank you for your question.

At the moment, the Snowflake Database node is a hard-coded to connect to snowflakecomputing.com. So there is no way for you to configure the node to reach your desired .cn url.

We have a ticket to introduce an advanced setting that makes the domain in the JDBC connection string configurable, so that you can change it to your desired URL. (Reference Ticket number : AP-23110).

The developers are working to fix this before the 5.3.2 release, but I can not gurantee you anything.

Best,
Keerthan

1 Like