(Glue-2411) App Upgrade Guide

Owned by SNP
Last updated: yesterday at 11:29 am by Marian Vidra
1 min read

Current after upgrade, version 1.30 → 1.31, steps:

  • Execute stored procedure call <app_name>.core.deploy_source_tasks( ).

This deploys necessary tasks in each source schema to enable support for delta-size-based merge on already created source schemas. New source schemas will have delta-size-based merge support enabled by default.

  • Execute stored procedure call <app_name>.core.deploy_merge( ).

Deploy merge stored procedure must be executed with storage settings as they were after the upgrade to mitigate the risk of side effects.

Before executing call <app_name>.core.deploy_merge( ) you can execute it on a subset of tables to check for side effects:

  • call <app_name>.core.deploy_merge('<DB>') -- Only in one Database

  • call <app_name>.core.deploy_merge('<DB>','<SCHEMA>') -- Only in one schema

  • call <app_name>.core.deploy_merge('<DB>','<SCHEMA>','<TABLE>') -- Only for one table

This re-deploys tasks and views for all tables. This enables support for statistics capture. New tables will have statistics capture support enabled by default.