Jump to content
We've recently updated our Privacy Statement, available here. ×

Spotfire Snowflake Key Pair Authentication ConfigurationIssue


Recommended Posts

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

Link to comment
Share on other sites

  • Mithun Vishwakarma changed the title to Spotfire Snowflake Key Pair Authentication ConfigurationIssue

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...