Save Button Remains Disabled When Switching to Key-Pair Authentication in Snowflake

Issue

When you switch your Snowflake destination's authentication method from username and password to key pair, Save & Test remains disabled.

Environment

• Destination: Snowflake
• Applies when switching the authentication method from username and password to key pair

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Snowflake destination page.
2. In the top right, click Actions, then click Edit connection details.
3. In the Default Virtual Warehouse dropdown list, click Load Virtual Warehouses and select a warehouse. Save & Test doesn't enable until this field is populated.
4. Confirm your Private Key includes the complete PEM wrapper:

   -----BEGIN PRIVATE KEY-----
   <private_key>
   -----END PRIVATE KEY-----
   

5. If your private key is encrypted, set the Is Private Key encrypted toggle to ON, then enter your Passphrase.
6. Click Save & Test.

For general guidance on switching to key-pair authentication in Snowflake, see Switching to Key-Pair Authentication.

If Save & Test still doesn't enable after completing the steps above, contact Fivetran Support. Include a screenshot of the Edit Connection Details page showing the Default Virtual Warehouse and authentication sections, and note any browser console or network errors.

Cause

This issue occurs when you switch authentication methods without first selecting a Default Virtual Warehouse. Fivetran doesn't enable Save & Test until a virtual warehouse is assigned to the destination.