You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Using encrypted key pair authentication to connect to Snowflake through integration agent

    in EPM Platform and Freeform 1 comment

    Summary:

    We are trying to connect to Snowflake using a JDBC driver through integration agent. I've added the following to my .ini file:

    [AGENT_JDBC_CONNECTIONS]
    snowflake_connection=jdbc:mySnowflake.snowflakecomputing.com
    snowflake_connection.user=myUserName
    snowflake_connection.private_key_file=myFilePath
    snowflake_connection.private_key_file_pwd=myPassword
    snowflake_connection.authenticator=snowflake_jwt

    When I run our integration, I get the following error:

    Private key provided is invalid or not supported: Use java.security.interfaces.RSAPrivateCrtKey.class for the private key

    It appears that the integration agent is not passing the private_key_file_pwd to the driver. Has anyone been successful connecting to Snowflake using encrypted key pair authentication?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!