The CREATE COMPUTE PROFILE statement defines the resource policy for a set of compute cluster instances.
Only users granted CREATE COMPUTE PROFILE privilege can create a compute profile.
Example:
CREATE COMPUTE PROFILE ShippingCluster01_Resources IN Research_Group, INSTANCE = TD_COMPUTE_SMALL USING MIN_COMPUTE_COUNT ( 1 ) MAX_COMPUTE_COUNT ( 2 ) SCALING_POLICY ('STANDARD') INSTANCE_TYPE ('STANDARD') INITIALLY_SUSPENDED ('FALSE') START_TIME ('') END_TIME ('') COOLDOWN_PERIOD ( 30 );
Parameters:
| Parameter | Description |
|---|---|
| COOLDOWN_PERIOD | [Optional] Specifies how long in minutes the compute cluster continues to run after the end time so that queries can complete before the compute cluster hibernates. |
| MIN_COMPUTE_COUNT | [Optional] Minimum number of expected active compute clusters in the compute group, an integer in the range [1, max_compute_count]. These compute clusters are primary. See the values of min_compute_count and max_compute_count with this command:
SELECT * FROM DBC.COMPUTEGROUPSVX;
Default: 1 |
| MAX_COMPUTE_COUNT | [Optional] Maximum number of compute clusters in the compute group, an integer 1 or greater. These compute clusters are secondary—automatic scaling brings them up and down. Default: 1 |
| INITIALLY_SUSPENDED | [Optional]
Default: False |
| INSTANCE |
|
| START_TIME and END_TIME | [Optional] Start and End times can be specified for when the compute cluster is operational in crontab format. |
| SCALING_POLICY |
|