Skip to main content

Append Name

The name affix that marks the batches, pipelines, packages, notebooks and objects generated for Delete Detection. A blank value falls back to the default DEL.

Depending on the artifact, the value is added as a suffix after an underscore or as a prefix before one. With the default value, delete detection batch names and Databricks job names include _DEL before their _Batch or _Job ending, delete detection notebook names include _DEL after the object name, and Data Factory delete detection loads into a database landing table add _DEL to the landing table name. Delete detection Data Factory pipeline names start with DEL_. SSIS delete detection packages are built with a batch name that has DEL_ in front of the batch name. When Delete Object Name Pattern is blank, the delete object is named with the object name followed by _DEL. When the pattern is set, the delete object name is built from the pattern and this affix is not added to it.

When to Change This Setting​

Keep the default DEL unless your naming convention calls for a different marker on delete detection artifacts.

SettingInteraction
Enable Delete DetectionEnables the delete detection artifacts this affix is applied to
Delete Object Name PatternNames the delete objects, with this affix as the fallback suffix when blank
Process On StageCalls the delete detection batch after the source to staging process

Notes​

  • This setting is part of the Delete Detection settings category.
  • The default value for this setting is DEL.