Skip to main content

Append Name External

The string to append to External tables when using PolyBase.

The external table's name is derived from the staged object name combined with this affix, positioned according to the Suffix Or Prefix Object setting. When a Schema Name Pattern or Object Name Pattern is used and the target is Azure Synapse Analytics, the @@stage token in those patterns resolves to this value.

When to Change This Setting​

Change it to match your naming standard for the external tables that expose staged files to PolyBase-based loads.

SettingInteraction
Append Name LandingThe equivalent affix for Landing tables
Schema Name PatternThe @@stage token resolves to this value on Azure Synapse targets
Object Name PatternThe @@stage token resolves to this value on Azure Synapse targets

Notes​

  • This setting is part of the Staging Naming settings category.
  • The default value for this setting is ext.