Skip to content

relationalai.api.engines

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: `S` (corresponds to `HIGHMEM_X64_S` instance family) `M` (corresponds to `HIGHMEM_X64_M` instance family) `L` (corresponds to `HIGHMEM_X64_L` instance family) `SL` (corresponds to `HIGHMEM_X64_SL` instance family) See Engine Sizes for more information.
`STATUS`	`STRING`	The current status of the engine. May be one of: `READY` `PENDING` `SUSPENDED` `UPGRADING`
`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                 |
  +------------------------+--------------+------+--------+----------------------+--------------------------------+-------------------------------+-----------------------------+-------------------------+-------------------+-------------------------+----------------------+ */

See Also