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

Microsoft Fabric Lakehouse lookups in mappings

Use a Microsoft Fabric Lakehouse Lookup transformation to look up data in a Microsoft Fabric Lakehouse object and retrieve data based on a specified lookup condition.
You can use the Microsoft Fabric Lakehouse Lookup transformation to look up the customer name in another Microsoft Fabric Lakehouse object. For example, the source table includes the customer code, but you want to include the customer name in the target table to make summary data easy to read.
You can create the following lookups when you configure field mappings in a mapping task:
You cannot configure an uncached lookup for mappings in advanced mode.
The following table describes the Microsoft Fabric Lakehouse lookup object properties that you can configure in a Lookup transformation:
Property
Description
Connection
Name of the lookup connection.
You can select an existing connection, create a new connection, or define parameter values for the lookup connection property.
If you want to overwrite the parameter 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.
You can switch between a non-parameterized and a parameterized Microsoft Fabric Lakehouse connection. When you switch between the connections, the advanced property values are retained.
Source Type
Type of the source object.
Select Single Object, Query, or Parameter.
Lookup Object
Name of the lookup object for the mapping.
Parameter
A parameter file where you define values that you want to update without having to edit the task.
Select an existing parameter for the lookup object or click New Parameter to define a new parameter for the lookup object.
The Parameter property appears only if you select parameter as the source type.
If you want to overwrite the parameter 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.
Define Query
The query to look up data when the selected source type is a query.
If the source type is a query, click Edit Custom Query, enter a valid custom query, and then click OK.
Multiple Matches
Behavior when the lookup condition returns multiple matches.
You can select from the following options in the lookup object properties to determine the behavior:
  • - Return first row1
  • - Return last row1
  • - Return any row
  • - Return all rows
  • - Report error
1Doesn't apply to mappings in advanced mode.
The following table describes the Microsoft Fabric Lakehouse lookup advanced properties that you can configure in a Lookup transformation:
Property
Description
Table Name Override
Overrides the table name of the imported Microsoft Fabric Lakehouse source table.
SQL Override
Overrides the default SQL query used to read data from the Microsoft Fabric Lakehouse source.
Tracing Level1
Sets the amount of detail that appears in the log file.
You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
Lookup Data Filter1
Limits the number of lookups that the mapping performs on the cache of the lookup source table based on the value you specify in the filter condition.
Maximum length of the filter condition is 32768 characters.
This property is applicable when you select object as the source type and enable lookup cache on the Advanced tab for the Lookup transformation.
For more information about this property, see Lookup source filter in Transformations in the Data Integration documentation.
1Doesn't apply to mappings in advanced mode.