relationalai.api.alter_reasoner_pool_node_limits()

alter_reasoner_pool_node_limits(
    type STRING,
    reasoner_size STRING,
    min_nodes INT,
    max_nodes INT
)

A procedure that updates the Snowflake compute pool node limits used by reasoners of the specified type and size. Each reasoner consumes one compute pool node while running. Requires the eng_admin application role.

Parameters

Name	Type	Description
type	STRING	Reasoner type. Valid values: 'logic', 'prescriptive', 'predictive'. Case-insensitive.
reasoner_size	STRING	Reasoner size (for example, 'HIGHMEM_X64_S'). Case-insensitive.
min_nodes	INT	Minimum nodes reserved for this type+size. Use NULL to leave unchanged. Must be <= max_nodes.
max_nodes	INT	Maximum nodes allowed for this type+size. Use NULL to leave unchanged. Must be >= min_nodes.

Returns

STRING — Returns Success on completion.

Example

Increase the maximum number of concurrently running logic reasoners of size HIGHMEM_X64_S to 12 (leave minimum unchanged):

CALL relationalai.api.alter_reasoner_pool_node_limits('logic', 'HIGHMEM_X64_S', NULL, 12);

Reserve 2 nodes (and allow up to 12) for logic reasoners of size HIGHMEM_X64_M:

CALL relationalai.api.alter_reasoner_pool_node_limits('logic', 'HIGHMEM_X64_M', 2, 12);

See Compute Pools for details on how node limits affect capacity and cost.