WARM UP
Description
The WARM UP COMPUTE GROUP statement is used to warm up data in a compute group to improve query performance. The warm-up operation can fetch resources from another compute group or specify particular tables and partitions for warming up. The warm-up operation returns a job ID that can be used to track the status of the warm-up job.
For information on how to warmup the cache for Catalog query scenarios, please refer to the Data Cache documentation.
Syntax
WARM UP COMPUTE GROUP <destination_compute_group_name> WITH COMPUTE GROUP <source_compute_group_name> FORCE;
WARM UP COMPUTE GROUP <destination_compute_group_name> WITH <warm_up_list>;
warm_up_list ::= warm_up_item [AND warm_up_item...];
warm_up_item ::= TABLE <table_name> [PARTITION <partition_name>];
Parameters
| Parameter Name | Description |
|---|---|
| destination_compute_group_name | The name of the target compute group to be warmed up. |
| source_compute_group_name | The name of the source compute group from which resources are obtained. |
| warm_up_list | A list of specific items to be warmed up, which can include tables and partitions. |
| table_name | The name of the table used for warming up. |
| partition_name | The name of the partition used for warming up. |
Return Value
- JobId: The ID of the warm-up job.
Access Control Requirements
Since 4.1.5, warming up requires USAGE on the destination Compute Group and, when specified, USAGE on the source Compute Group. Each internal table explicitly listed with WITH TABLE requires SELECT. Event-driven warm-up using ON TABLES rules additionally requires global ADMIN. The operation is rejected if any required privilege is missing.
Examples
- Warm up the compute group named destination_group_name using the compute group named source_group_name
WARM UP COMPUTE GROUP destination_group_name WITH COMPUTE GROUP source_group_name;
- Warm up the tables sales_data and customer_info, and the partition q1_2024 of the table orders using the compute group named destination_group.
WARM UP COMPUTE GROUP destination_group WITH
TABLE sales_data
AND TABLE customer_info
AND TABLE orders PARTITION q1_2024;