Resolved as the source entity name in load execution.
Supported in all loads.
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