Spotfire Snowflake Key Pair Authentication ConfigurationIssue

[Mithun Vishwakarma]

Currently I am facining issue in configuring key pair authentication in setting up data connection, I have confirfured encrypted key path and provided path in datasource template and i am getting issue on invalid configuration. Please can anyone help if you have allready configured key pair authenticaiton. ?

 

Datasource template:

 

<jdbc-type-settings>
<type-name>Snowflake</type-name>
<driver>net.snowflake.client.jdbc.SnowflakeDriver</driver>
<connection-url-pattern>jdbc:snowflake://&lt;ACCOUNT&gt;.snowflakecomputing.com</connection-url-pattern>
<supports-catalogs>true</supports-catalogs>
<supports-schemas>true</supports-schemas>
<supports-procedures>false</supports-procedures>
<fetch-size>10000</fetch-size>
<batch-size>100</batch-size>
<use-ansii-style-outer-join>true</use-ansii-style-outer-join>
<connection-properties>
<connection-property>
<key>rsa_key_unencrypted.p8</key>
<value>E:\tibco\tss\12.0.9\tomcat\certs\</value>
</connection-property>
</connection-properties>
</jdbc-type-settings>

 

Information link designer connection URL

 

jdbc:snowflake://xxxxx.snowflakecomputing.com/?private_key_file=E:\tibco\tss\12.0.9\tomcat\certs\rsa_key_unencrypted.p8&authenticator=snowflake_jwt&User=USER_ID

[Peter McKinnis]

Mithun,

According to the Java stacktrace in the log file which you provided via email, the Snowflake JDBC driver is rejecting the connection string:

--------

Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: Connection string is invalid. Unable to parse.
at net.snowflake.client.jdbc.SnowflakeDriver.connect(SnowflakeDriver.java:185) ~[snowflake-jdbc-3.14.2.jar:3.14.2]

---------

I suggest the following changes:

(1) Remove the <connection-property> with the rsa_key_unencrypted.p8 from the data source template.  rsa_key_unencrypted.p8 is not a valid property for the Snowflake driver.

(2) Based on searching the web, I always see examples of the Snowflake private key including private_key_file and private_key_file_pwd in the connection string.  You can check with Snowflake to see if both are required or not. 

(3) Recommend using a unix path separator since Java will be parsing the path, e.g. E:/tibco/tss/12.0.9/tomcat/certs/rsa_key_unencrypted.p8, again Snowflake should tell you what the driver is expecting.

 

Since the error is coming from the Snowflake driver, Snowflake should be able to guide you on what is expected by the JDBC driver.

Regards,

Peter

P.S.  I sent the above information to you in an email too last week and not sure if you received it or not.