Open Table Connector

Back Next

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:

Select the Target transformation in the mapping.

To specify the target, click the

Target

tab.

Select the target connection.

For the target type, choose

Single Object

Parameter

Specify the target object or parameter.

To specify a target object, perform the following tasks:

Click

Select

and choose a target object. You can select an existing target object or create a new target object at runtime.

To create a target object at runtime, select

Create New at Runtime

In the

Object Name

field, enter the name of the target table that you want to create.

In the

Catalog Name with Database Name

field, enter the AWS Glue catalog name and database name in the following format:

In the

Table Location

field, enter the location of the target table data.

Specify the table properties to optimize the table configuration settings.

Click

The following image shows a sample target object:

Rename Saved Search

Table of Contents

Open Table Connector

Open Table Connector

Create a target table at runtime

Create a target table at runtime