A.24 Incremental Workspace Refresh

Incremental workspace refresh helps to get the incremental data for new date from the source or adding additional partition to an existing table with respect to changes in the source.

As a part of incremental workspace refresh, all partitioned tables used in the workspace schema should be enabled to handle auto partition.

Enable partition table to auto partition, follow these steps:

1. Configuring a list of partitioned tables to enable auto partition. Changes to be made in the Sandbox workspace schema are as follows:
   1. Update or insert the record in table “ml4aml_range_auto_partition_config” with PARTITION_FLAG as Y. Update other records which do not require to enable with PARTITION_FLAG as N.
2. Login to Compliance Studio installed UNIX Machine.
3. Navigate to <Compliance_Studio_HOME>/deployed/ml4aml/bin directory.
4. Execute the following UNIX command:

   ./enableRangeAutoPartition.sh -w <sandbox_wallet_alias>