relationalai.app.upgrade_status_details

upgrade_status_details

A view with status information about engines upgraded during the RelationalAI (RAI) Native App upgrade process. Requires the app_admin application role.

Columns

Column	Type	Description
ENGINE_NAME	STRING	The name of the engine.
STATE	STRING	The current state of the engine upgrade.
MESSAGE	STRING	Message with details about the specific state.
STARTED_AT	TIMESTAMP	The time when the engine upgrade process started.
LAST_UPDATE	TIMESTAMP	The time when the engine upgrade status was last updated.

Example

Use the app.upgrade_status_details view to check the status of engines being upgraded during the RAI Native App upgrade process:

SELECT * FROM relationalai.app.upgrade_status_details;
/*+--------------+---------+-------+-------------------------------+-------------------------------+
  | ENGINE_NAME  | MESSAGE | STATE | STARTED_AT                    | LAST_UPDATE                   |
  |--------------+---------+-------+-------------------------------+-------------------------------|
  | john_doe     | Running | DONE  | 2024-10-27 08:11:32.490 -0700 | 2024-10-27 08:17:45.108 -0700 |
  | maria_garcia | Running | DONE  | 2024-10-27 08:11:32.490 -0700 | 2024-10-27 08:17:45.108 -0700 |
  | mark_jones   | Running | DONE  | 2024-10-27 08:11:32.490 -0700 | 2024-10-27 08:17:45.108 -0700 |
  +--------------+---------+-------+-------------------------------+-------------------------------+ */

For more information on upgrading the RAI Native App, see Upgrades.

See Also

• app.upgrade()
• app.upgrade_status
• app.get_release()