I have a dataset which I want to continuously build until it aborts. The pseudocode of my transform looks something like:
def my_transform(input, output):
antijoin output onto input to remove rows we've already processed
if there are no rows left in the input, abort
otherwise process the first 100 rows and write them to the output as an append
We can't do all the processing in a single build because there are sometimes too many rows to process and the build would fail if we tried to process all of them.
Is there some way to set up a schedule so that if there is new output, it builds the output dataset again (as if the dataset was both a trigger and target dataset)?