engines#
relationalai.api
#engines
A view that provides information about available RelationalAI (RAI) engines.
Requires the eng_user application role.
Columns#
| Column | Type | Description |
|---|---|---|
NAME | STRING | The name of the engine. |
ID | STRING | The unique identifier of the engine. |
SIZE | STRING | The size of the engine. May be one of:
|
STATUS | STRING | The current status of the engine. May be one of:
|
CREATED_ON | TIMESTAMP | The timestamp when the engine was created. |
UPDATED_ON | TIMESTAMP | The timestamp when the engine was last updated. |
COMPUTE_POOL | STRING | The name of the engine’s host compute pool. |
VERSION | STRING | The engine version number. |
AUTO_SUSPEND_MINS | INT | The number of minutes of inactivity before the engine is automatically suspended. If 0, the engine will never auto-suspend. |
SUSPENDS_AT | TIMESTAMP | The timestamp when the engine will auto-suspend due to inactivity. NULL if the engine is not scheduled for suspension. |
AWAIT_STORAGE_VACUUM | BOOLEAN | Whether the engine waits for garbage collection tasks to finish before suspending. |
Example#
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 |
+------------------------+--------------+------+--------+----------------------+--------------------------------+-------------------------------+-----------------------------+-------------------------+-------------------+-------------------------+----------------------+ */