Using ApplyMapping to remap data property keys - Amazon Glue Studio
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Using ApplyMapping to remap data property keys

An ApplyMapping transform remaps the source data property keys into the desired configured for the target data. In an ApplyMapping transform node, you can:

  • Change the name of multiple data property keys.

  • Change the data type of the data property keys, if the new data type is supported and there is a transformation path between the two data types.

  • Choose a subset of data property keys by indicating which data property keys you want to drop.

You can add additional ApplyMapping nodes to the job diagram as needed – for example, to modify additional data sources or following a Join transform.

Note

The ApplyMapping transform is not case-sensitive.

To add an ApplyMapping transform node to your job diagram

  1. (Optional) Choose Transform in the toolbar at the top of the visual editor, and then choose ApplyMapping to add a new transform to your job diagram, if needed.

  2. On the Node properties tab, enter a name for the node in the job diagram. If a node parent isn't already selected, choose a node from the Node parents list to use as the input source for the transform.

  3. Choose the Transform tab in the node details panel.

  4. Modify the input schema:

    • To rename a data property key, enter the new name of the key in the Target key field.

    • To change the data type for a data property key, choose the new data type for the key from the Data type list.

    • To remove a data property key from the target schema, choose the Drop check box for that key.

  5. (Optional) After configuring the transform node properties, you can view the modified schema for your data by choosing the Output schema tab in the node details panel. The first time you choose this tab for any node in your job, you are prompted to provide an IAM role to access the data. If you have not specified an IAM role on the Job details tab, you are prompted to enter an IAM role here.

  6. (Optional) After configuring the node properties and transform properties, you can preview the modified dataset by choosing the Data preview tab in the node details panel. The first time you choose this tab for any node in your job, you are prompted to provide an IAM role to access the data. There is a cost associated with using this feature, and billing starts as soon as you provide an IAM role.