Skip to content

relationalai.app.upgrade_status

upgrade_status

A view containing status details of the RelationalAI (RAI) Native App engine upgrade process. Requires the app_admin application role.

Columns

Column	Type	Description
`NA_VERSION`	`STRING`	The current version of the RAI Native App. This is the same version returned by the `app.get_release()` function.
`ATTEMPT`	`NUMBER`	The number of times the current upgrade has been retried. `NULL if no upgrades have been attempted.
`STATE`	`STRING`	The current state of the upgrade. `DONE` when the upgrade is complete. The `app.finalize_upgrade()` procedure must then be called to complete the upgrade process.
`ENGINE_COUNT`	`STRING`	The number of engines that have been upgraded.
`STARTED_AT`	`TIMESTAMP`	The time when the upgrade process started.
`LAST_UPDATE`	`TIMESTAMP`	The time when the upgrade status was last updated.

Example

Use the app.upgrade_status view to check the status of the RAI Native App engine upgrade process:

SELECT * FROM relationalai.app.upgrade_status;
/*+-------------------------+---------+-------+--------------+-------------------------------+-------------------------------+
  | NA_VERSION              | ATTEMPT | STATE | ENGINE_COUNT | STARTED_AT                    | LAST_UPDATE                   |
  |-------------------------+---------+-------+--------------+-------------------------------+-------------------------------|
  | 2024.10.27-e829e39d     | 1       | DONE  | 9            | 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