Comment on page
WAREHOUSE
Config path:
/warehouse.yaml
Example:
task_wh:
size: XSMALL
auto_suspend: 60
multi_custer_wh:
size: SMALL
min_cluster_count: 1
max_cluster_count: 4
auto_suspend: 60
- {key} (ident) - warehouse name
- {value} (dict)
- size (str) - warehouse size
- min_cluster_count (int) - (default: 1)
- max_cluster_count (int) - (default: 1)
- scaling_policy (str) - (default: STANDARD)
- auto_suspend (int) - number of idle seconds before warehouse is automatically suspended (default: 60)
- global_resource_monitor (ident) - name of resource monitor created externally
- query_acceleration_max_scale_factor (int)
- warehouse_params (dict)
- {key} (ident) - warehouse param name
- {value} (bool, float, int, str) - warehouse param value
- comment (str)
- 1.
- 2.
- 3.
resource_monitor
can only be applied by user withACCOUNTADMIN
role. - 4.All warehouses are created with
INITIALLY_SUSPENDED
andAUTO_RESUME
enabled.
Last modified 1yr ago