Error: Fetch Standard Config Failed

Issue

While setting up a Snowflake connection, authentication succeeds, but schema discovery fails with the following error:

Something went wrong. Error while getStandardConfig. Type: INTEGRATION_FAILURE. Details: Fetch standard config failed.

Environment

Connector: Snowflake

Resolution

To resolve this issue, use Snowflake SECURITYADMIN role, or an equivalent role, to do the following:

1. Confirm that the warehouse exists:

   SHOW WAREHOUSES LIKE '<WAREHOUSE_NAME>';
   

2. Set a default warehouse for the Fivetran user. Snowflake requires a default warehouse at the user level for proper session initialization:

   ALTER USER <FIVETRAN_USER> SET DEFAULT_WAREHOUSE = '<WAREHOUSE_NAME>';
   

3. Grant warehouse usage to the Fivetran role:

   GRANT USAGE ON WAREHOUSE <WAREHOUSE_NAME> TO ROLE <FIVETRAN_ROLE>;
   

After completing these steps, re-run schema discovery. The schemas should populate successfully.

Cause

This issue occurs when the Snowflake user doesn't have a default warehouse configured, even if the Fivetran role has access to a warehouse. Snowflake requires a default warehouse at the user level to initialize sessions properly. Without one, Fivetran can't retrieve the standard configuration, causing schema discovery to fail.