Virtual Warehouse Selection for Connector SDK Connections

Issue

I can't configure the virtual warehouse for my Connector SDK connector through the CLI. How is the virtual warehouse assigned, and can I change it after the connection is created?

Environment

Fivetran Connector SDK with a Snowflake destination

Resolution

Although you can't set a specific virtual warehouse during CLI-based connector creation, you can update the virtual warehouse assignment at any point after the connection is created — including after incremental syncs have already run.

To update the virtual warehouse for your connection, use one of the following methods:

• Setup form: In the Fivetran dashboard, open the connector's Setup tab, choose edit and update the virtual warehouse field.

• REST API: Use the Fivetran REST API to update the connector configuration programmatically. Set the destination_configuration.virtual_warehouse field in the request body to the desired virtual warehouse name:

  {
    "destination_configuration": {
      "virtual_warehouse": "<warehouse_name>"
    }
  }
  

Cause

Virtual warehouse selection is not configurable from the Fivetran Connector SDK CLI at the time of connector creation. When a connector is created, Fivetran automatically assigns the default virtual warehouse that is configured for the destination. This is the expected behavior for SDK-based connections.