reasoners

relationalai.api

reasoners

A view that lists all existing RAI reasoners. Requires the eng_user application role.

Columns

Column	Type	Description
NAME	STRING	Reasoner name.
TYPE	STRING	Reasoner type.
ID	STRING	Reasoner identifier.
SIZE	STRING	Reasoner size (instance family).
STATUS	STRING	Reasoner status.
CREATED_BY	STRING	Creator identifier.
CREATED_ON	TIMESTAMP_LTZ	Creation time.
UPDATED_ON	TIMESTAMP_LTZ	Last update time.
VERSION	STRING	Reasoner version.
AUTO_SUSPEND_MINS	INT	Auto-suspend inactivity window in minutes.
SUSPENDS_AT	TIMESTAMP_LTZ or NULL	Scheduled suspend time (if applicable).
SETTINGS	STRING	Serialized settings payload.
RUNTIME	STRING	Runtime information.

Example

List all reasoners:

SELECT * FROM relationalai.api.reasoners;

Filter for idle reasoners (ready and scheduled to suspend):

SELECT *
FROM relationalai.api.reasoners
WHERE status = 'READY' AND suspends_at IS NOT NULL;

See Compute Resources for more usage patterns.