Snowflake connections support password-based authentication and key-pair authentication; choose the method that matches how your Snowflake user is configured.

1. On the Authentication step of the wizard, configure one of the authentication options.
2. To configure Key pair (Private Key) authentication:
   1. Select Key pair (Private Key).
   2. In the Private Key field, paste the RSA private key for the Snowflake user in the PEM (Privacy-Enhanced Mail) format.
      The private key will be stored securely and not displayed after submission.
   3. (Optional) In the Private Key Passphrase field, enter a passphrase only if the private key is encrypted with a passphrase.
3. To configure Key pair (Public Key) authentication:
   1. Select Key pair (Public Key).
   2. Paste the RSA public key in the PEM (Privacy-Enhanced Mail) format.
      You must add this public key to your Snowflake user to enable key pair authentication.
4. To configure Password authentication:
   1. Select Password.
   2. Enter the password for the Snowflake username specified on the Basic Info step.
5. (Optional) to configure the Advanced Query History:
   Use Advanced Query History Configuration only if your Snowflake administrator gives you a specific table or view to use for tracking query status. By setting Query History Object Type and Query History Object Name, you tell Mediation exactly which Snowflake object to query to determine whether a Snowflake query has completed and what its final status is, instead of relying on the default behavior. Most users can leave these fields blank and use the default query-status handling.
   1. Click on Advanced Query History Configuration.
   2. For Query History Object Type, select whether the query history object is a TABLE or VIEW.
      This selection is required when an object name is specified.
   3. In the Query History Object Name field, enter the fully qualified name of the Snowflake table or view.
      Mediation will query this object to check query execution status.
6. Click Save & Continue.