CREATE SHADOW RULE

• Duplicate ruleName cannot be created;
• resourceMapping specifies the mapping relationship between the source database and the shadow library. You need to use the resource 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 ;

Create a shadow rule

CREATE SHADOW RULE shadow_rule(
  SOURCE=demo_ds,
  SHADOW=demo_ds_shadow,
  t_order((simple_hint_algorithm, TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"))),(TYPE(NAME="REGEX_MATCH", PROPERTIES("operation"="insert","column"="user_id", "regex"='[1]')))), 

CREATE, SHADOW, RULE, SOURCE, SHADOW, TYPE, NAME,

• Reserved word