What is the Optimal Configuration of Snowflake for Fivetran?

Use Case/Scenario:

You are configuring Snowflake for optimized use with Fivetran.

Fivetran Recommendation:

1. Warehouse size is X-Small
2. Auto-suspension and auto-resumption are enabled

If you created your Snowflake warehouse according to the Fivetran setup guide, these configurations are automatically applied.

These recommendations are best practice in the vast majority of cases. Unless you are bulk loading a large number of files concurrently (i.e. hundreds, or thousands of files), a smaller warehouse is generally sufficient. Using a larger warehouse will consume more credits and may not result in any noticeable performance improvement.

Considerations:

Syncing less data won't necessarily result in lower Snowflake cost, as there is a minimum of billable compute time.