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. |
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 |
|------------------------+--------------+------+--------+----------------------+--------------------------------+-------------------------------+-----------------------------+-------------------------|
| 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 |
| 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 |
+------------------------+--------------+------+--------+----------------------+--------------------------------+-------------------------------+-----------------------------+-------------------------+ */