(Glue-2405) App Upgrade Guide

Owned by SNP
May 21, 2024
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 upgrade to mitigate risk of side effects.

Before executing call <app_name>.core.deploy_merge( ) you can execute it on 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.