Be aware that a row count test is a superficial check that jobs produce It is not a Unit Testof the number of rows produced by a job, and should not be considered a real (or particularly valuable) Unit Test. That being said, there are times when a row count check can be useful - particularly when it’s difficult to curate a manageable value of test data.
The MettleCI unit testing feature allows you to thoroughly check that your jobs produce the expected outputs, given a specific set of inputs. If you don’t yet have some or all of your test data ready for a job, you can run a unit test in row count only mode for some or all outputs. This means that, instead of testing that the job output exactly matches what was expected, the unit test harness will only test that the number of rows output by the job matches the number of rows that were expected.
...