finalize_upgrade() Deprecated #

#
<Namespace>relationalai.app</Namespace>

```sql
finalize_upgrade()

A procedure that completes the RelationalAI (RAI) Native App engine upgrade process. Requires the app_admin application role.

DANGER

This procedure was deprecated in version 2025.3.25-94a100b-1 and will be removed in a future release. Its functionality has been integrated into the app.upgrade() procedure. Calling app.finalize_upgrade() is now a no-op and returns a deprecation warning.

Parameters#

None.

Returns#

STRING

Example#

After calling app.upgrade(), use the app.finalize_upgrade() procedure to complete the engine upgrade process:

#CALL relationalai.app.finalize_upgrade();
/*+---------------------------------+
  | Upgrade completed successfully. |
  +---------------------------------+ */
IMPORTANT

Ensure that the STATE column of the app.upgrade_status view shows DONE before calling app.finalize_upgrade().

All engines deleted during the upgrade are recreated. Python queries whose transactions were cancelled during the upgrade do not resume automatically.

See Upgrades for more information on upgrading the RAI Native App.

See Also#