A standard Medium virtual warehouse is used to load data continuously. The data will be consumed through reports.
Which action will optimize costs?
Separate warehouses isolate continuous loading from reporting, allowing each workload to be independently sized and managed. Because the loading warehouse remains active continuously, reports can use their own warehouse and incur compute only according to their reporting demand rather than sharing the continuously running load compute. Snowflake recommends dedicated warehouses for loading and querying operations.
Community Discussion