field-mapper.md

FieldMapper

FieldMapper transform plugin

Description

Add input schema and output schema mapping.

Options

name	type	required	default value
field_mapper	Object	yes

field_mapper [config]

Specify the field mapping relationship between input and output

common options [config]

Transform plugin common parameters, please refer to Transform Plugin for details.

Example

The data read from source is a table like this:

id	name	age	card
1	Joy Ding	20	123
2	May Ding	20	123
3	Kin Dom	20	123
4	Joy Dom	20	123

We want to delete age field and update the filed order to id, card, name and rename name to new_name. We can add FieldMapper transform like this

transform {
  FieldMapper {
    source_table_name = "fake"
    result_table_name = "fake1"
    field_mapper = {
        id = id
        card = card
        name = new_name
    }
  }
}

Then the data in result table fake1 will like this

id	card	new_name
1	123	Joy Ding
2	123	May Ding
3	123	Kin Dom
4	123	Joy Dom

Changelog

new version

• Add Copy Transform Connector