source_entity_name

Resolved as the source entity name in load execution.

See also:

• source_entity_schema

• target_entity_name

• target_schema

• Variables

• Entities

Usage

<source_entity_name>

Notes

Supported in all loads.

If used in a load with multiple entity mappings, source_entity_schema and source_entity_name refer to the first entity mapping (position = 1). Also see entity mapping types.

Examples

Variable used in an OVERRIDE load step

OVERRIDE load step in a load with an entity mapping with source entity staging.STG_ADVENTUREWORKS_DEPARTMENT:

select
  ...
from <source_entity_schema>.<source_entity_name>

Load executed in the target database:

select
  ...
from staging.STG_ADVENTUREWORKS_DEPARTMENT