> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Configure Snowflake authentication

> Snowflake connections support password-based authentication and key-pair authentication. On the Authentication step of the wizard, configure one of the authentication options.

Snowflake connections support password-based authentication and key-pair authentication. On the Authentication step of the wizard, configure one of the authentication options.

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.

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.

To configure Password authentication:

1. Select **Password**.
2. Enter the password for the Snowflake username specified on the Basic Info step.

(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.

Click **Save & Continue**.