Example 1: Compute group name is specified, INSTANCE TYPE is not
The following statement creates the ShippingCG01 compute profile in the Shipping compute group on the TD_COMPUTE_MEDIUM instance and defines a minimum of 1 and a maximum of 5 compute cluster instances, respectively. INSTANCE TYPE is STANDARD by default.
CREATE COMPUTE PROFILE ShippingCG01 IN Shipping, INSTANCE = TD_COMPUTE_MEDIUM USING MIN_COMPUTE_COUNT(1) MAX_COMPUTE_COUNT(5) INITIALLY_SUSPENDED('FALSE');
*** Compute Profile has been created.
Example 2: Compute group name and INSTANCE TYPE are not specified
The following statement creates the ShippingCG compute profile on the TD_COMPUTE_MEDIUM instance and uses the default compute group name from the user session, user profile, or user. INSTANCE TYPE is STANDARD by default.
CREATE COMPUTE PROFILE ShippingCG02, INSTANCE = TD_COMPUTE_MEDIUM USING MIN_COMPUTE_COUNT(1) MAX_COMPUTE_COUNT(5) INITIALLY_SUSPENDED('FALSE');
*** Compute profile has been created.
Example 3: Creating a compute profile on an analytic compute group
If compute group analytic_group has QUERY_STRATEGY (ANALYTIC), the following statement creates the ShippingCG03 compute profile in analytic_group on the TD_COMPUTE_MEDIUM instance and defines a minimum of 1 and a maximum of 5 compute cluster instances, respectively.
If analytic_group has QUERY_STRATEGY (STANDARD), the following statement causes an error.
CREATE COMPUTE PROFILE ShippingCG03 IN analytic_group, INSTANCE = TD_COMPUTE_MEDIUM, INSTANCE TYPE = ANALYTIC USING MIN_COMPUTE_COUNT (1) MAX_COMPUTE_COUNT (5) INITIALLY_SUSPENDED ('FALSE');