This may not be possible for every destination, but for Snowflake destination, it would be great to have an option to use a particularly sized warehouse for a given connector.

For example, we run over 80 ingestions using fivetran.   All are fine on the default warehouse, which is XSMALL.

Now we are needing to do our first really big ingestion, and we need to use a MED warehouse.  In order to do this, i need to:

• create a new destination
• a new user
• a new role
• a new warehouse
• whitelist IPs
• etc etc

I basically have to set up another destination that is basically the same as the old one.

A possible (easy) solution.   When first setting up a destination, allow us to create more than 1 warehouse on initial setup and have both warehouses be usable by the fivetran user/role.  1 warehouse is deemed teh default (the XSMALL), the others optional.  In the connector setup form, give the person a chance to override the default WH