Use Case/Scenario:
You want to configure Snowflake for optimized use with Fivetran.
Fivetran Recommendation:
- 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.