How to Apply Column-Level Schema Transformations

Locate the attribute to update

Add a schema consolidation search value

You may need to horizontally scroll in the editable grid.

For the JSON Tutorial, use:

Y|Cre|Shipment

Add a schema consolidation SQL expression

For the JSON tutorial, use:

CONCAT('|',REGEXP_SUBSTR(OBJECT_KEYS(VARIANT_COL)::STRING, 'Y\|Cre\|Shipment\|(\d+)', 1, 1, 'e', 1))

Add more schema consolidation search and expression values

For the JSON tutorial, apply the same values as above to the Y|Cre|Shipment.shipment_status attribute.

Click save to apply changes