ALTER SHADOW RULE

    • storageUnitMapping specifies the mapping relationship between the source database and the shadow library. You need to use the storage unit managed by RDL, please refer to ;
    • shadowAlgorithm can act on multiple shadowTableRule at the same time;
    • If algorithmName is not specified, it will be automatically generated according to ruleName, tableName and shadowAlgorithmType;
    • currently supports VALUE_MATCH, REGEX_MATCH and SQL_HINT.
    • Create a shadow rule
    1.   SOURCE=demo_ds,
    2.   SHADOW=demo_ds_shadow,
    3.   t_order(TYPE(NAME="SQL_HINT")), 
    4.   t_order_item(TYPE(NAME="VALUE_MATCH", PROPERTIES("operation"="insert","column"="user_id", "value"='1')))