When you configure a mapping in advanced mode to use an Open Table target, you can configure the target properties.
Specify the name and description of the Open Table target. Configure the target and advanced target properties for the Open Table object in a Target transformation.
The following table describes the Open Table source properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
You can select an existing connection, create a new connection, or define parameter values for the source 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.
Target Type
Type of the Open Table target object.
You can choose from the following source types:
- Single Object. Select to specify a single Open Table object.
- Parameter. Select to specify a parameter name. You can configure the target object in a mapping task associated with a mapping that uses this Target 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 target object or click New Parameter to define a new parameter for the target object.
The Parameter property appears only if you select parameter as the target type.
If you want to overwrite the target 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.
Object
Name of the target object.
You can select an existing object from the list or create a target object at run time. For information on creating the target object at run time, see the Create a target table at runtime topic.
Operation
Select the target operation. You can perform the Insert operation on an Open Table target.
The following table describes the Open Table source advanced property that you can configure in a Target transformation:
Property
Description
S3 Properties
The S3FileIO properties that you want to configure.
Enter 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.bucket1=<S3 bucket ARN>
s2.multipart.threshold=1.5
Note: The S3 bucket ARN property is mandatory when the source and target are in different regions.
Create a target table at runtime
You can use an existing target or create a target to hold the results of a mapping. If you choose to create the target, the agent creates the target if it does not exist already when you run the task.
To specify the target properties, perform the following tasks:
1Select the Target transformation in the mapping.
2To specify the target, click the Target tab.
3 Select the target connection.
4For the target type, choose Single Object or Parameter.
5Specify the target object or parameter.
6 To specify a target object, perform the following tasks:
aClick Select and choose a target object. You can select an existing target object or create a new target object at runtime.
bTo create a target object at runtime, select Create New at Runtime.
cIn the Object Name field, enter the name of the target table that you want to create.
dIn the Catalog Name with Database Name field, enter the AWS Glue catalog name and database name in the following format: <CatalogName>/<DatabaseName>.
eIn the Table Location field, enter the location of the target table data.
fSpecify the table properties to optimize the table configuration settings.
