Question
What is the optimal configuration of Snowflake for Fivetran?
Environment
Destination: Snowflake
Recommendation
- The warehouse size is X-Small.
- Auto-suspension and auto-resumption are enabled.
These configurations are automatically applied if you created your Snowflake warehouse according to the Fivetran setup guide.
These recommendations are Best Practices for the vast majority of cases. A smaller warehouse is generally sufficient unless you are bulk loading a large number of files concurrently (i.e., hundreds or thousands of files). 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.