Can I set test failure thresholds?

This is not currently supported in dbt natively.

Instead, consider: