I have a table in Snowflake that is joined with another one. Then it is updated based on some column that is brought through the joining.
Now, this operation should be done until no change is made to the initial table.
Is there an elegant way to do so in Matillion?
Thank you for your help!
I've not completely thought this through. But I think it'd involve using the "Export" tab from the update component, to record the number of rows updated. Then using that value in an "if" component in the orchestration job, to decide if the job should "end success" or loop around. You might also be able to do the same sort of thing using the loop iterator, by updating the variable it uses.