Skip to content
Create Extract Transform Load \(ETL\) definitions › Robust Import Set Transformers › Import sets › Imports › Workflow Data Fabric
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Create ETL entity field definitions

Define the entity fields mapped for Extract Transform Load (ETL) operations.

Before you begin

Role required: import_transformer

Procedure

  1. Navigate to All > System Import Sets > Administration > ETL Definitions.

  2. Select an ETL definition.

  3. On the ETL Entities tab, select an ETL entity.

  4. On the ETL Entity fields tab, click New.

  5. Complete the form.

FieldDescription
NameName of the ETL Entity field definition.
Field/PathThe column name in the staging or import set table. For reference fields in a target entity, you can specify the columns to map data to. For example, suppose you're mapping data to an address table with three columns: number, street, and postal code. You can specify the unique column to map to by entering `address.number`, `address.postal_code`, and `address.street`. When specifying unique columns in reference fields, all must have the same coercion action and coalesce value. For example, all three address fields listed previously must have the same coercion action and the same coalesce value. For an import entity, a field within an array can be referenced with the \[\*\] notation. For example, for the following nested structure, you can specify the email address by entering `emails[*].address`. 
{
      "id": "123",
      "name": "Jhon",
      "emails": [
        {
          "address": "jhon@servicenow.com",
          "type": "work"
        },
      ]
    }
Coercion actionWhat the system should do if a reference or choice could not be found. Available options are create, ignore, and reject.- For the create option, the system creates a new reference/choice and assigns it to the current record. - The ignore option sets the current value as empty. - The reject option does not save the whole record to the database.
CoalesceUse this field to query the existing records.
ApplicationApplication scope for this record.
EntityName of the robust transform engine entity.
DefinitionSelected ETL entity that this field definition belongs to.
  1. Click Submit.