You can configure a primary cloud data warehouse where you normally load data. When you do this, the mappings in SQL ELT mode that you create are automatically configured to load data to this target. You can still change the target if you wish.

You can configure a primary cloud data warehouse destination only for one of the following types of data warehouses: Amazon Redshift, Databricks, Google BigQuery, Microsoft Fabric Data Warehouse, or Snowflake.

The cloud data warehouse that you choose applies to the organization that you're currently logged into. If you have access to multiple organizations, you can configure a different primary cloud data warehouse for each organization and sub-organization.

The setup steps vary based on whether you've already configured a primary cloud data warehouse. If you've already configured one, you can change or unselect it.