Write dbt test for positive values

Question

Is there an easy way to write a test for a column being positive in dbt?

accepted_values doesn't seem to work for continuous vatiables.

I know you can write queries in ./tests but it looks like an overkill for such a simple thing.

user_2846588 · Answer

You could use dbt_utils.expression_is_true

version: 2

models:
  - name: model_name
    tests:
      - dbt_utils.expression_is_true:
          expression: "col_a > 0"

user_10797428 · Answer

I think the dbt_utils suggestion is good, the only reasonable alternative I can think of is writing a custom schema test:

But why bother when you can just use expression_is_true @jake