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.