CREATE COMPUTE_POOL

Syntax

CREATE COMPUTE_POOL compute_pool_name
WITH (compute_pool_parameter = value [, …]);

Description

A compute pool is a set of dedicated resources used to run batch queries. You define a compute pool at the organization level. It follows the same RBAC rules as any other DeltaStream object.

Only a role with CREATE_COMPUTE_POOL privilege can create a compute_pool.

Arguments

compute_pool_name

The name of the compute_pool to define. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

Compute Pool Parameters

Parameter Name	Description
compute_pool.size	Required: Yes Default value: None Type: String Valid values: Small, Medium, Large Small - 1 compute worker (8cpu, 6Gi memory) Medium - Small x 2 Large - Small x 4
compute_pool.timeout_min	If a compute_pool is idle for timeout_min, it will be stopped. Required: No Default value: 60 minutes (3600 seconds) Type: Int

Examples

CREATE COMPUTE_POOL mypool 
WITH(‘compute_pool.size’=small, ‘compute_pool.timeout_min’ =3600);