add_field

Add fields to a record

Add fields to a record

Option 1 (alternative): Add multiple fields

Properties

Name Type Description Required
fields object[] Fields
 yes

Additional Properties: not allowed

Example

source:
  server_name: redislabs
  schema: dbo
  table: emp
transform:
  - uses: add_field
    with:
      fields:
        - field: name.full_name
          language: jmespath
          expression: concat([name.fname, ' ', name.lname])
        - field: name.fname_upper
          language: jmespath
          expression: upper(name.fname)

Option 2 (alternative): Add one field

Properties

Name Type Description Required
field string Field
 yes
expression string Expression
 yes
language string Language
Enum: "jmespath", "sql"
 yes

Additional Properties: not allowed

Example

source:
  server_name: redislabs
  schema: dbo
  table: emp
transform:
  - uses: add_field
    with:
      field: country
      language: sql
      expression: country_code || ' - ' || UPPER(country_name)

Option 1: fields[]: array

Fields

Items

Item Properties

Name Type Description Required
field string Field
 yes
expression string Expression
 yes
language string Language
Enum: "jmespath", "sql"
 yes

Item Additional Properties: not allowed

Example

- {}
RATE THIS PAGE
Back to top ↑