Extracting field transformation from app load script

MichelLalancette — Sat, 16 Nov 2024 01:31:34 GMT

Is there a way, using the API, to retrieve the transformations applied to a field during the data load script?

For example:

MyTable:

LOAD num(mystringfield) as MyNumField

RESIDENT tmp_table;

I'd like to retrieve the final field name (MyNumField) as well as the transformation applied (num(mystringfield)).

I know some tools like Nodegraph do this kind of task (lineage) but we're not big enough to warrant such a tool and was also interested in trying it myself. I have been unable to find this information so far.

topic Extracting field transformation from app load script in Integration, Extension & APIs

Extracting field transformation from app load script