Schema Name Pattern
Specific override behavior for the schema name for staging tables and other database assets.
When set, the target schema for objects staged from a source connection is built from this pattern instead of the default behavior. The pattern supports three tokens:
| Token | Resolves to |
|---|---|
@@rs | The Record Source code of the connection |
@@stage | The landing affix, or the external affix on Azure Synapse targets |
@@schema | The object's original schema (dbo when blank) |
The pattern does not apply to Data Vault objects, Data Mart dimension/fact tables, or objects on Persistent Staging Area connections — those keep their modeled schemas. When the pattern is blank (the default), the standard behavior applies, including the Record Source-as-schema convention when Use Record Source As Schema is enabled.
When to Change This Setting
Set it when your environment mandates a specific schema convention for staging assets — for example a fixed stg schema, or a composite such as @@rs_@@schema to combine record source and source schema.
Related Settings
| Setting | Interaction |
|---|---|
| Object Name Pattern | The equivalent pattern for the object name |
| Delete Schema Name Pattern | The equivalent pattern for delete-detection objects |
| Use Record Source As Schema | The default schema convention that applies when this pattern is blank |
Notes
- This setting is part of the Staging Naming settings category.