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	Current reasoner status. See Reasoner statuses.
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.

Reasoner statuses

Status	Description
READY	The reasoner is running and ready to use.
PENDING	The reasoner is not ready yet. It might be starting, resuming, provisioning an endpoint, or finishing its configuration. Wait and check the status again.
SUSPENDING	The reasoner is being suspended. Wait until the status changes to SUSPENDED.
SUSPENDED	The reasoner is suspended. Call api.resume_reasoner_async() to resume it before use.
UPGRADING	The reasoner is being upgraded. Wait and check the status again before using it.
DELETING	The reasoner is being deleted. Wait until it no longer appears in api.reasoners.
FAILED	The reasoner’s service failed. Delete it with api.delete_reasoner(), then recreate it with api.create_reasoner().
GONE	The reasoner’s service no longer exists, but its metadata remains. Delete the stale reasoner with api.delete_reasoner(), then recreate it with api.create_reasoner().

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 Manage reasoners for more usage patterns.