Unable to Save Snowflake Destination After Switching to Key-Pair Authentication

Issue

After switching from username/password authentication to key-pair authentication, the Save & Test button remains disabled.

Environment

Destination: Snowflake

Resolution

To resolve this issue:

1. In Fivetran, go to your Snowflake destination page.
2. In the top right, select the more options menu, then click Edit connection.
3. From the Default Virtual Warehouse drop-down menu, select Load Virtual Warehouses, then select a warehouse.
4. Ensure your Private Key includes the complete PEM wrapper:

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

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

If the button remains disabled, contact our support team with a screenshot of the Edit Connection Details page showing the authentication and Default Virtual Warehouse sections, along with any browser console or network errors.

For more information, see Configure key-pair authentication.

Cause

This issue occurs when you don't select a Default Virtual Warehouse or your private key doesn't include the required PEM wrapper.