You can parameterize the connection, objects, and the advanced runtime properties in mappings.
To parameterize the connection, objects, and the advanced runtime properties using a parameter file, create the parameters in the Parameters panel when you create a mapping. Then, define the parameters in the parameter file, place the parameter file in the following location, and run the mapping task:
Consider the following rules and guidelines when you use parameterization:
General guidelines
When you create a mapping with a parameterized target that you want to create at runtime, set the target field mapping to automatic.
You cannot parameterize the field mapping.
Mappings
When you use input parameters, specify the parameter name in the following format:
Format in a mapping task: $name$
Format in a parameter file: $name
When you use in-out parameters, specify the parameter name in the following format in a mapping task or a parameter file: $$name.
You cannot parameterize a Microsoft Fabric OneLake target created at runtime. Instead, you can specify the parameter in the Lakehouse Override to parameterize the target using a parameter file. Specify the parameter in the following format: $$name or $name.
ASK INFAPreview
