Can I set test failure thresholds?

This is not currently supported in dbt natively.

Instead, consider:

• Setting the severity to warn, or:
• Writing a custom generic test that accepts a threshold argument (example)