Adding new fields to a managed entity

Users can add a new field to a managed entity. Multiple fields can be added one at a time.

In the source module, users first select the entity to append the field to. Note that fields will only be appended to the end of entities and fields screen must be accessed from the entity grid by selecting icon view fields (View Fields) icon from the parent entity. See Properties Impacted by Schema Evolution By Source below for information on properties that will be affected by this schema change.

Additions and deletions to fields in Mainframe entities are not supported. Metadata definitions for COBOL Mainframe entities must be declared through COBOL copybooks.

access field functionality by drilling to fields from entity — View fields from entity grid

In fields tab, select Add Fieldbutton

Add Field button is in top left of fields grid — Adding field

Add field wizard first screen requires field name and data type and displays relevant properties — Add Field wizard example creates a new field Name LEVEL and Data Type CHAR

Review: For this example field Name 'LEVEL' and external Data Type 'CHAR'; the application retains the Field Name and maps to internal Data Type (over-writable via dropdown).

User input maps to internal name and data type displays on review step — Review

Confirm screen details the associated dataflows and user views that will be invalidated by this change if any exist.

The entity has been updated with new field metadata and is ready for ingest of those field values. The same entity and the new field can be viewed in discover now displaying the internal data type.

Click to view full size — New “LEVEL” field displaying in source

Properties Impacted by Schema Evolution By Source
Source	Properties Affected	Required Action
JDBC	src.file.glob	Manually add explicit field to SELECT statement
-	header.validation.pattern	Manually add column header (field name) to Header Pattern
Flat File	src.file.glob	Manually add explicit field to SELECT statement
-	header.validation.pattern	Manually add column header (field name) to Header Pattern
JSON	HEN file	Must be modified
XML	xml.entity.xslt	Must be modified
-	header.validation.pattern	Manually add column header (field name) to Header Pattern
Mainframe	cobol.copybook	Must be modified

For more information, see also Schema change detection for JDBC addressed and registered entities

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here