I have now changed the setting in dbt_project.yml from:

tests:
  +store_failures: false

tests:
  +store_failures: true

After making this change, the test failure table is now being pushed to Snowflake, and it includes all failures from both my singular test and generic tests. This make sense, but I'm interested in storing my singular tests.

I still don't fully understand why setting store_failures: false at the project level prevented even explicitly configured tests (store_failures=True) from storing failures. If anyone can clarify this behavior in DBT, I’d appreciate it!