Support prefect task retries

[jon-mic]

Prefect has built-in support for retrying failed tasks: https://docs.prefect.io/2.10.12/tutorial/flow-task-config/#flow-and-task-retries
This could be handy in case there are networking issues or database blocks when running dbt models.

[kiyanmair]

We've been feeling this limitation as well and had to implement an ugly workaround. I took a quick look through the repo and it seems like this might be an easy fix. I'll open a PR and link to this issue.