Microsoft Fabric Lakehouse Connector > Mappings and mapping tasks with Microsoft Fabric Lakehouse Connector > Microsoft Fabric Lakehouse targets in mappings
  

Microsoft Fabric Lakehouse targets in mappings

To write data to a Microsoft Fabric Lakehouse, configure a Microsoft Fabric Lakehouse object as a target in a mapping or mapping in advanced mode.
The following table describes the target properties that you can configure for a Microsoft Fabric Lakehouse target:
Property
Description
Connection
Name of the target connection.
Select an existing connection, create a new connection, or define parameter values for the target connection property.
If you want to overwrite the target connection properties at runtime, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties. Ensure that the parameter file is in the correct format.
Specify the parameter file directory and name in the advanced session properties.
When you switch between a non-parameterized and a parameterized Microsoft Fabric Lakehouse connection, the advanced property values are retained.
Target Type
Type of the Microsoft Fabric Lakehouse target object.
Select one of the following source types from the list:
  • - Single Object. Select to specify a single Microsoft Fabric Lakehouse object.
  • - Parameter. Select to specify a parameter name. You can configure the target object in a mapping task associated with a mapping or mapping in advanced mode that uses this Target transformation.
Default is Single Object.
Parameter
A parameter file where you define values that you want to update without having to edit the task.
The Parameter property appears only if you select the target type as Parameter.
Select an existing parameter for the target object or click New Parameter to define a new parameter for the target object.
If you want to overwrite the target connection properties at runtime, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties. Ensure that the parameter file is in the correct format.
Object
Name of the Microsoft Fabric Lakehouse target object.
Specify the target object that you want to create. You can also select an existing object from the list.
Operation
Type of target operation.
Select Insert, Update, or Delete.
Default is Insert.
You can only perform an insert operation in a mapping.
You cannot perform data driven operation in a mapping or mapping in advanced mode.
The following table describes the advanced target properties that you can configure for a Microsoft Fabric Lakehouse target:
Property
Description
Update Mode
Loads data to the target based on the mode you select.
This property is applicable when you select the Update target operation.
Select one of the following modes:
  • - Update As Update. Updates all rows flagged for update if the entries exist.
  • - Update Else Insert. The agent first updates all rows flagged for update if the entries exist in the target. If the entries do not exist, the agent inserts the entries.
Table Name Override
Overrides the table name configured in the target object and uses the specified table name to write data at runtime.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the mapping task forwards rejected rows to the next transformation.
If you select the Forward Rejected Rows option, the Secure Agent flags the rows for reject and writes them to the reject file.
If you do not select the Forward Rejected Rows option, the Secure Agent drops the rejected rows and writes them to the session log file. The Secure Agent does not write the rejected rows to the reject file.