Add a spark or sql transform

Is it possible to apply a regular transformation (sql or spark) on a field before aggregating it trough AggregatedTransform?

example: Query is SELECT ... max(case when x = 'xName' then cast(jsonField['fieldA'] as integer) end) as max_fieldA ... from BLA

Ideally I'd like to just select jsonField['fieldA'] on the query and apply the transformation in the feature definition before applying the "max" aggregation

Thans ^^

May 13 '21 23:05 diogo-lucena-wildlife