PipeRider
Search…
Built-In Assertions
Out-of-the-box assertions and usage examples.
You can go to .piperider/assertions/ to add assertions in <table>.yml.
Here are built-in assertions, there are two types of assertions, one takes no parameter, the other takes parameters.

Column Assertion

assert_column_exist

  • Description: The column must exist.
  • Assert: None
  • Tags:
YAML example

assert_column_in_types

  • Description: The type of the column must be contained in the list.
  • Assert:
    • types: [numeric, string, datetime]
  • Tags:
YAML example

assert_column_min_in_range

  • Description: The minimum value of the column must be between min_value and max_value.
  • Assert:
    • min: [min_value, max_value]
  • Tags:
YAML example

assert_column_max_in_range

  • Description: The maximum value of the column must be between min_value and max_value.
  • Assert_:_
    • max: [min_value, max_value]
  • Tags:
YAML example

assert_column_not_null

  • Description: The values of the column must not be null.
  • Assert: None
  • Tags:
YAML example

assert_column_null

  • Description: The values of the column must be null.
  • Assert: None
  • Tags:
YAML example

assert_column_type

  • Description: The type of the column must match the specified type.
  • Assert:
    • type: numeric, string, datetime
  • Tags:
YAML example

assert_column_schema_type

  • Description: The column schema type must match a specified schema type.
  • Assert:
    • schema_type: TEXT, DATE, VARCHAR(128), or etc...
  • Tags:
YAML example

assert_column_unique

  • Description: The values of column must be unique.
  • Assert: None
  • Tags:
YAML example

Table Assertion

assert_row_count

  • Description: The row count must be >= min or <= max. If min is not specified, it is assumed to be 0. If max is not specified, it is assumed to be infinity. If min and max are both specified, min must be less than or equal to max.
  • Assert:
    • min: min_count
    • max: max_count
  • Tags:
YAML example

assert_row_count_in_range

  • Description: The row count must be between min_count and max_count.
  • Assert:
    • count: [min_count, max_count]
  • Tags:
YAML example
Copy link
On this page
Column Assertion
assert_column_exist
assert_column_in_types
assert_column_min_in_range
assert_column_max_in_range
assert_column_not_null
assert_column_null
assert_column_type
assert_column_schema_type
assert_column_unique
Table Assertion
assert_row_count
assert_row_count_in_range