Add Field Transformation

The Add Field transformation plugin is available in the Hub.

Adds a new field to each record. The field value can either be a new UUID, or it can be set directly through configuration. This transformation is used when you want to add a unique id field to each record, or when you want to tag each record with some constant value. For example, you may want to add the logical start time as a field to each record.

Configuration

Property

Macro Enabled?

Description

Property

Macro Enabled?

Description

Field Name

No

Required. The name of the field to add. Must not already exist as an input field. The field type will be a nullable string.

Field Value

Yes

Optional. The value to set for the new field. If this is not specified, Generate UUID as Value must be set to true. 

Generate UUID as Value

No

Optional. Generate a new UUID for the new field. If this is not true, Field Value must be specified.

Default is false.

Examples

This example adds a new field called logicalStartTime that is set to the logical start time of the run:

Property

Value

Property

Value

Field Name

logicalStartTime

Field Value

${logicalStartTime(yyyy-MM-dd'T'HH-mm-ss)}

This example adds a new field called ‘id’ that is set to a new UUID for each record:

Property

Value

Property

Value

Field Name

id

Generate UUID as Value

true

Created in 2020 by Google Inc.