Assert record count of table matches provided assertion. Exception thrown when assertion fails.

Syntax

assert count table <table reference> <assertion operator> <count>

Parameters

table reference

String. Name of the table to show, optionally qualified by a schema name.

assertion operator

String. Operator from following: ==, !=, <=, >=, <, >

count

Integer. The number of rows to assert against.