Testing Columns
Column tests are meant to check for null and unique values, and are always run after transformations. This cannot be changed unless using a user-defined node.
Example Column Test
- Click on Testing → Column.
- Select both Unique and Null.
- Now click on Null next to
C_NATIONKEY
. This will check to ensure all entries for this column are populated (not null). - Run the node and it should succeed, as there's no null entries.
- Now try also selecting Unique for the
C_NATIONKEY
column. This will check to ensure all entries for this column are unique. - Run the node and it will fail, as
C_NATIONKEY
has repeated entries. Notice that the data was still processed, as column tests will always continue on failure.
Updated 22 days ago