Append Name Landing
The string to append to Landing tables when deploying using Azure Data Factory Copy directly to the database.
The landing table's name is derived from the staged object name combined with this affix, positioned according to the Suffix Or Prefix Object setting. Delete-detection objects staged through the landing layer carry the same affix. When a Schema Name Pattern or Object Name Pattern is used, the @@stage token in those patterns resolves to this value (on Azure Synapse targets the external affix is used instead).
When to Change This Setting
Change it to match your naming standard for the landing tables that receive data copied directly into the database ahead of the staging load.
Related Settings
| Setting | Interaction |
|---|---|
| Append Name External | The equivalent affix for External (PolyBase) tables |
| Schema Name Pattern | The @@stage token resolves to this value on non-Synapse targets |
| Delete Object Name Pattern | Delete objects derived through the landing layer include this affix |
Notes
- This setting is part of the Staging Naming settings category.
- The default value for this setting is
land.