Pushdown first. Most of these are a
CASE, a split_part or a
cast, and the source can do them without a row moving. Platform compute is
for what a source cannot express or does not hold.
Pushdown is the difference between owning a compute cluster per customer and owning a SQL compiler. Only the two that genuinely cannot push down are run here.
Reshaping something the business recorded is a transform. Producing something it never recorded is inference, and it gets a different word on this screen and a different treatment downstream.
ict_asset_inventory.dependencies is required and
nothing at Nordbank holds it. It can be approximated from incidents that
took several assets down together, and that approximation is worth
having, but it is a derivation with a confidence, not a
binding. It is marked as such, it carries its own coverage number, and an
answer that leans on it says so.