Open Table Connector > Mappings and mapping tasks with Open Table Connector > Open Table lookups in mappings
  

Open Table lookups in mappings

In a mapping in advanced mode, you can configure a Lookup transformation to represent an Open Table object.
You can retrieve data from an Open Table lookup object based on the specified lookup condition.
The following table describes the Open Table lookup 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 target connection properties at run time, select the Allow parameter to be overridden at run time option.
Source Type
Type of the Open Table lookup object.
Select one of the following lookup object types:
  • - Single Object. Select to specify a single Open Table object.
  • - Parameter. Select to specify a parameter name. You can configure the lookup object in a mapping task associated with a mapping that uses this Lookup transformation.
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 lookup object at run time, select the Allow parameter to be overridden at run time option.
When the task runs, the Secure Agent uses the parameters from the file that you specify in the advanced session properties.
Lookup Object
Name of the Open Table lookup object.
Multiple Matches
The behavior when the lookup condition returns multiple matches.
You can select one of the following options:
  • - Return any row
  • - Return all rows
  • - Report error
For more information about configuring lookups, see the Transformations guide in the Data Integration documentation.
The following table describes the Open Table lookup advanced properties that you can configure in a Lookup transformation:
Property
Description
Iceberg Spark Properties
The properties that you want to configure for the Iceberg tables.
Enter the properties in the following format:
<parameter name>=<parameter value>
If you enter more than one property, enter each property in a new line.
For example,
s3.access-points.<bucket name>=<S3 bucket ARN>
BucketRegion=<bucket-region-name>
Note: The S3 bucket ARN property is mandatory when the source and target are in different regions. For more information, see the Create the ARN for your AWS S3 bucket KB article.
Delta Spark Properties
The properties that you want to configure for the Delta Lake tables.
Enter the properties in the following format:
<parameter name>=<parameter value>
If you enter more than one property, enter each property in a new line.
For example,
BucketRegion=<bucket-region-name>