Snowflake Behaviour Change - MFA

Support
4

Hi Albert,

I was able to connect to Snowflake using a SERVICE account and a key-pair authentication with the following steps:

  1. Create a key pair as described here
  2. Create a new service account with the generated public keys as follows:
CREATE USER
    <name>
    TYPE = SERVICE
    RSA_PUBLIC_KEY = 'MIIBIjANBgkqh...'
    [ other account properties ]
  1. Grant permissions to the create account
  2. Make the following changes to the native Snowfake connector in EasyMorph:
    • Set the name of the created account to the "User" option
    • Leave the "Password" option empty
    • Add the following custom properties:
      • AUTHENTICATOR = snowflake_jwt
      • PRIVATE_KEY_FILE = <path_to_generated_private_key>

Looks like it's not possible to use the PRIVATE_KEY connection property in EasyMorph, but we will discuss internally if we should add support for this authorization method directly to the connector settings.