Skip to content

relationalai.api.engines

engines

A view that provides information about available RelationalAI (RAI) engines. Requires the eng_user application role.

ColumnTypeDescription
NAMESTRINGThe name of the engine.
IDSTRINGThe unique identifier of the engine.
SIZESTRINGThe size of the engine. May be one of:
  • S (corresponds to HIGHMEM_X64_S instance family)
  • M (corresponds to HIGHMEM_X64_M instance family)
STATUSSTRINGThe current status of the engine. May be one of:
  • READY
  • PENDING
  • SUSPENDED
  • UPGRADING
CREATED_ONTIMESTAMPThe timestamp when the engine was created.
UPDATED_ONTIMESTAMPThe timestamp when the engine was last updated.
COMPUTE_POOLSTRINGThe name of the engine’s host compute pool.
VERSIONSTRINGThe engine version number.
AUTO_SUSPEND_MINSINTThe number of minutes of inactivity before the engine is automatically suspended. If 0, the engine will never auto-suspend.
SUSPENDS_ATTIMESTAMPThe timestamp when the engine will auto-suspend due to inactivity. NULL if the engine is not scheduled for suspension.
AWAIT_STORAGE_VACUUMBOOLEANWhether the engine waits for garbage collection tasks to finish before suspending.

Use the api.engines view to retrieve available engines:

SELECT * FROM relationalai.api.engines;
/*+------------------------+--------------+------+-------+-----------------------+--------------------------------+-------------------------------+-----------------------------+-------------------------+-------------------+-------------------------+----------------------+
| NAME | ID | SIZE | STATUS | CREATED_BY | CREATED_ON | UPDATED_ON | COMPUTE_POOL | VERSION | AUTO_SUSPEND_MINS | SUSPENDS_AT | AWAIT_STORAGE_VACUUM |
|------------------------+--------------+------+--------+----------------------+--------------------------------+-------------------------------+-----------------------------+-------------------------|-------------------+-------------------------+----------------------|
| CDC_MANAGED_ENGINE | b7c1d8f9a2b3 | S | READY | SYSTEM | 2024-10-27 15:22:15.500 -0700 | 2024-10-27 15:22:16.731 -0700 | RELATIONAL_AI_HIGHMEM_X64_S | 2024.10.27-e829e39d | 0 | NULL | false |
| john_doe | e4f5a6d7c8e9 | M | READY | john.doe@company.com | 2024-10-27 17:29:53.110 -0700 | 2024-10-27 17:29:54.319 -0700 | RELATIONAL_AI_CPU_X64_M | 2024.10.27-e829e39d | 60 | 2024-10-27 18:29:53.110 | true |
+------------------------+--------------+------+--------+----------------------+--------------------------------+-------------------------------+-----------------------------+-------------------------+-------------------+-------------------------+----------------------+ */