Today I fixed the error on DBT job step by simply running dbt run --full-refresh locally.
What if Fivetran's deployment.yml file had tags something like
- name: dev_15min
- name: run-dbt-dev
command: dbt run --project-dir ./<folder>
command: ["SELECT ... FROM METADATA", "EXECUTE PROC SP_SOME"]
command: dbt run --project-dir ./<folder> --full-refresh
command: ["SELECT ... FROM..."]
In my experience full-refresh could fix many failing jobs, and for Fivetran framework this would be just an additional (conditional) step for dbt commands. As dbt framework grows, having the conditional steps could become more useful.
SQL steps would need certainly need a different implementation.