Skip to main content

Assert Table Count

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.