SQL failures in dbt run should be reported as yellow

[fatchat]

Similar to how we report dbt test failures as yellow

• create a new prefect state
• assign in webhook

The new state will continue to show as RED in the pipeline overview, but the ops team should be able to filter them out of failure reports

[fatchat]

when a client's SQL fails, we show it to them as RED in their pipeline summary

but since the platform did not fail, prefect should show GREEN

but the pipeline will need to stop at that point, so prefect should treat it as a failure

and failure notifications should be triggered

[fatchat]

@himanshudube97 replicate two types of failures:

1. dbt not found
2. incorrect sql

see if prefect can distinguish the two