1.8 Unit Testing Expected Result

[jenna-adams]

Hi,
I have a query that will not return any rows when certain criteria are met. I want to use a unit test to test this sad path, but I don't know what to put in the 'expect' part of the schema. Does anyone know what to put here?

mau_unit_tests:
    -  name: test_mau_sad_path
       description: "shows all clients with more than 40 users"
       model: mau_model
       given:
         -  input: usage_events
            rows:
              -  {...}
         -  input: clients
            rows:
              - {...}
       expect: ????

[jeremyyeo]

https://github.com/jeremyyeo/the-hitchhikers-guide-to-dbt/tree/main/dbt-unit-tests#expect-output-to-have-no-rows

[jenna-adams]

Thank you!!!