You can see that the Flow failed because one of the Tasks failed:

image.png

This is how the Flow is defined:

image.png

In other flows we have, when on_failure id defined, when the Flow finishes in Failed state, we can see in the logs a log that says that the on_failure is executing.

But in this case, we see no such log.

Link to the Flow run:

For example, this is how it looks on another Flow we have, in which the on_failure hook works ok:

image.png

In contrast, we can't find that

Running hook 'on_failure_email' in response to entering state 'Failed'

log line in the logs.

Here is the complete raw logs for the Run. You can search and see that there is no "Running hook..." log line inside:

asparagus-tarantula.csv