# Overview This article provides a quick overview of the data validation features in Pointblank. It introduces the key concepts and shows examples of the main functionality, giving you a foundation for using the library effectively. Later articles in the **User Guide** will expand on each section covered here, providing more explanations and examples. # Validation Methods Pointblank's core functionality revolves around validation steps, which are individual checks that verify different aspects of your data. These steps are created by calling validation methods from the [Validate](../../reference/Validate.md#pointblank.Validate) class. When combined they create a comprehensive validation plan for your data. Here's an example of a validation that incorporates three different validation methods: ``` python import pointblank as pb import polars as pl ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Three different validation methods." ) .col_vals_gt(columns="a", value=0) .rows_distinct() .col_exists(columns="date") .interrogate() ) ```
Pointblank Validation
Three different validation methods. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C 1
col_vals_gt()
a 0 ✓ 13 13
1.00		 0
0.00		 -- -- -- --
#4CA64C66 2
rows_distinct()
ALL COLUMNS -- ✓ 13 11
0.85		 2
0.15		 -- -- -- CSV
#4CA64C 3
col_exists()
date -- ✓ 1 1
1.00		 0
0.00		 -- -- -- --
This example showcases how you can combine different types of validations in a single validation plan: - a column value validation with [Validate.col_vals_gt()](../../reference/Validate.col_vals_gt.md#pointblank.Validate.col_vals_gt) - a row-based validation with [Validate.rows_distinct()](../../reference/Validate.rows_distinct.md#pointblank.Validate.rows_distinct) - a table structure validation with [Validate.col_exists()](../../reference/Validate.col_exists.md#pointblank.Validate.col_exists) Most validation methods share common parameters that enhance their flexibility and power. These shared parameters (overviewed in the next few sections) create a consistent interface across all validation steps while allowing you to customize validation behavior for specific needs. # Column Selection Patterns You can apply the same validation logic to multiple columns at once through use of column selection patterns (used in the `columns=` parameter). This reduces repetitive code and makes your validation plans more maintainable: ``` python import narwhals.selectors as nws # Map validations across multiple columns ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Applying column mapping in `columns`." ) # Apply validation rules to multiple columns --- .col_vals_not_null( columns=["a", "b", "c"] ) # Apply to numeric columns only with a Narwhals selector --- .col_vals_gt( columns=nws.numeric(), value=0 ) .interrogate() ) ``` xNzgyMTk5Nyw4LjkxODk3OTc1IDUuODAzNzUwNDYsOC45MTg5Nzk3NSBDNy40MjkyODA5NSw4LjkxODk3OTc1IDguNzUxNzE4MDcsMTAuMjQxNDE2OSA4Ljc1MTcxODA3LDExLjg2Njk0NzQgQzguNzUxNzE4MDcsMTMuNDkyNDc3OCA3LjQyOTI4MDk1LDE0LjgxNDkxNSA1LjgwMzc1MDQ2LDE0LjgxNDkxNSBaIiBpZD0iU2hhcGUiIGZpbGw9IiMwMDAwMDAiIGZpbGwtcnVsZT0ibm9uemVybyIgLz4KICAgICAgICAgICAgPHBhdGggZD0iTTEzLjk2MzgxODksOC42OTkzMzUgQzEzLjkzNjQ2MjEsOC43MDQzMDkyNSAxMy45MDkxMDU5LDguNzExNzY5NjggMTMuODg0MjM1OSw4LjcxOTIzMDc0IEMxMy43ODIyNzA0LDguNzM2NjM5NjcgMTMuNjg3NzY1NCw4Ljc3NjQzMTE1IDEzLjYwNTY5NTYsOC44Mzg2MDUxOCBMMTAuMjQzMzE1NiwxMS4zODUyNTk4IEMxMC4wNzY2ODg2LDExLjUwNDYzNDMgOS45NzcyMDk5MywxMS42OTg2MTgxIDkuOTc3MjA5OTMsMTEuOTAyNTQ5MSBDOS45NzcyMDk5MywxMi4xMDY0ODA3IDEwLjA3NjY4ODYsMTIuMzAwNDYzOSAxMC4yNDMzMTU2LDEyLjQxOTgzODMgTDEzLjYwNTY5NTYsMTQuOTY2NDkzIEMxMy44OTE2OTcsMTUuMTgwMzcyNSAxNC4yOTcwNzI5LDE1LjEyMzE3MjEgMTQuNTEwOTUxNywxNC44MzcxNzA3IEMxNC43MjQ4MzEzLDE0LjU1MTE2OTIgMTQuNjY3NjMwOSwxNC4xNDU3OTQgMTQuMzgxNjI5NCwxMy45MzE5MTQ1IEwxMi41MzEzMjU3LDEyLjUzOTIxMjcgTDIxLjg4MTI0OTUsMTIuNTM5MjEyNyBMMjEuODgxMjQ5NSwxMS4yNjU4ODU0IEwxMi41MzEzMjU3LDExLjI2NTg4NTQgTDE0LjM4MTYyOTQsOS44NzMxODM2NCBDMTQuNjM3Nzg3Miw5LjcxNjUwNDUzIDE0Ljc0OTcwMDYsOS40MDA2NjAxNCAxNC42NDc3MzUxLDkuMTE3MTQ1NTMgQzE0LjU0ODI1NjQsOC44MzM2MzE1NiAxNC4yNjIyNTUsOC42NTk1NDM1MiAxMy45NjM4MTg5LDguNjk5MzM1IFoiIGlkPSJhcnJvdyIgZmlsbD0iIzAwMDAwMCIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoMTUuOTI5MjMwLCAxMS44OTQ3MzcpIHJvdGF0ZSgtMTgwLjAwMDAwMCkgdHJhbnNsYXRlKC0xNS45MjkyMzAsIC0xMS44OTQ3MzcpICIgLz4KICAgICAgICA8L2c+CiAgICA8L2c+Cjwvc3ZnPg==" />
Pointblank Validation
Applying column mapping in `columns`. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C 1
col_vals_not_null()
a -- ✓ 13 13
1.00		 0
0.00		 -- -- -- --
#4CA64C 2
col_vals_not_null()
b -- ✓ 13 13
1.00		 0
0.00		 -- -- -- --
#4CA64C66 3
D0iI0ZGRkZGRiIgLz4KICAgICAgICAgICAgPHBhdGggZD0iTTQwLjYxMjA4MDUsNDcuMDM3ODM0IEMzNy40NjkyMzQ4LDQ3LjAzNzgzNCAzNS4wMTI2MTM5LDQ1LjkzNDg2MTMgMzMuNzEyMjM0LDQ0LjAxNDA1OTcgQzMyLjQxMTg1NDEsNDUuOTM0ODYxMyAyOS45NTUyMzMxLDQ3LjAzNzgzNCAyNi44MTIzODgzLDQ3LjAzNzgzNCBDMjIuNjU3NDM5Nyw0Ny4wMzc4MzQgMTYuMDY0NjcxMiw0My40NDM3NzIzIDE2LjA2NDY3MTIsMzMuODAyMTYxOSBDMTYuMDY0NjcxMiwyOS4zNDAxMzYxIDE3LjQ3MTU4NzksMTguOTYyMTY2IDMwLjUwMzU4NjIsMTguOTYyMTY2IEMzMC45NDU0MDE4LDE4Ljk2MjE2NiAzMS4zMDU3NDgxLDE5LjMyMjUxMjQgMzEuMzA1NzQ4MSwxOS43NjQzMjc5IEwzMS4zMDU3NDgxLDIxLjM2ODY1MTggQzMxLjMwNTc0ODEsMjEuODEwNDY3NCAzMC45NDU0MDE4LDIyLjE3MDgxMzggMzAuNTAzNTg2MiwyMi4xNzA4MTM4IEMyNi42NDAwNDg2LDIyLjE3MDgxMzggMjIuNDgxOTY2OCwyNS44MTE4Nzc0IDIyLjQ4MTk2NjgsMzMuODAyMTYxOSBDMjIuNDgxOTY2OCwzNy41MDkwMjc3IDIzLjc2MzU0NTYsNDMuMDI3MDI0MyAyNy4yOTQ5Mzg0LDQzLjAyNzAyNDMgQzI5Ljc5NTQyOCw0My4wMjcwMjQzIDMxLjIyNDI3OSw0MC40MjMxMzEyIDMyLjA5ODUwOTUsMzguMjg2MTIyMSBDMzAuNTA2NzE5NCwzNS42MTAxNTk2IDI5LjcwMTQyNDMsMzMuMTAzNDAzNSAyOS43MDE0MjQzLDMwLjgzNDc4OTIgQzI5LjcwMTQyNDMsMjUuNjIzODcwNyAzMS44NjAzNjc3LDIzLjc3NTEzNzcgMzMuNzEyMjM0LDIzLjc3NTEzNzcgQzM1LjU2NDEwMDIsMjMuNzc1MTM3NyAzNy43MjMwNDM3LDI1LjYyMzg3MDcgMzcuNzIzMDQzNywzMC44MzQ3ODkyIEMzNy43MjMwNDM3LDMzLjEzNDczODMgMzYuOTM5NjgyOCwzNS41Nzg4MjU1IDM1LjMyOTA5MTYsMzguMjg2MTIyMSBDMzYuNjI5NDcxNSw0MS40MzIxMDA5IDM4LjI0MzE5Niw0My4wMjcwMjQzIDQwLjEyOTUyOTUsNDMuMDI3MDI0MyBDNDMuNjYwOTIyMyw0My4wMjcwMjQzIDQ0Ljk0MjUwMTIsMzcuNTA5MDI3NyA0NC45NDI1MDEyLDMzLjgwMjE2MTkgQzQ0Ljk0MjUwMTIsMjUuODExODc3NCA0MC43ODQ0MTkzLDIyLjE3MDgxMzggMzYuOTIwODgxNywyMi4xNzA4MTM4IEMzNi40NzU5MzI5LDIyLjE3MDgxMzggMzYuMTE4NzE5OCwyMS44MTA0Njc0IDM2LjExODcxOTgsMjEuMzY4NjUxOCBMMzYuMTE4NzE5OCwxOS43NjQzMjc5IEMzNi4xMTg3MTk4LDE5LjMyMjUxMjQgMzYuNDc1OTMyOSwxOC45NjIxNjYgMzYuOTIwODgxNywxOC45NjIxNjYgQzQ5Ljk1Mjg4MDEsMTguOTYyMTY2IDUxLjM1OTc5NjcsMjkuMzQwMTM2MSA1MS4zNTk3OTY3LDMzLjgwMjE2MTkgQzUxLjM1OTc5NjcsNDMuNDQzNzcyMyA0NC43NjcwMjgyLDQ3LjAzNzgzNCA0MC42MTIwODA1LDQ3LjAzNzgzNCBaIiBpZD0ib21lZ2EiIGZpbGw9IiMwMDAwMDAiIGZpbGwtcnVsZT0ibm9uemVybyIgLz4KICAgICAgICAgICAgPHBhdGggZD0iTTMzLDcuOTM1OTc3MDUgQzMzLjI3NjE0MjQsNy45MzU5NzcwNSAzMy41LDguMTU5ODM0NjcgMzMuNSw4LjQzNTk3NzA1IEwzMy41LDU3LjU2NDAyMyBDMzMuNSw1Ny44NDAxNjUzIDMzLjI3NjE0MjQsNTguMDY0MDIzIDMzLDU4LjA2NDAyMyBDMzIuNzIzODU3Niw1OC4wNjQwMjMgMzIuNSw1Ny44NDAxNjUzIDMyLjUsNTcuNTY0MDIzIEwzMi41LDguNDM1OTc3MDUgQzMyLjUsOC4xNTk4MzQ2NyAzMi43MjM4NTc2LDcuOTM1OTc3MDUgMzMsNy45MzU5NzcwNSBaIiBpZD0ibGluZV9ibGFjayIgZmlsbD0iIzAwMDAwMCIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoMzMuMDAwMDAwLCAzMy4wMDAwMDApIHJvdGF0ZSgtMzIwLjAwMDAwMCkgdHJhbnNsYXRlKC0zMy4wMDAwMDAsIC0zMy4wMDAwMDApICIgLz4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9ImxpbmVfd2hpdGUiIGZpbGw9IiNGRkZGRkYiIHRyYW5zZm9ybT0idHJhbnNsYXRlKDM0Ljg5OTQ5NiwgMzIuMTUzMzAzKSByb3RhdGUoLTMyMC4wMDAwMDApIHRyYW5zbGF0ZSgtMzQuODk5NDk2LCAtMzIuMTUzMzAzKSAiIHBvaW50cz0iMzQuMzk5NDk2MiA4LjU0MTYwNDY5IDM1LjM5OTQ5NjIgOC41NDE2MDQ2OSAzNS4zOTk0OTYyIDU1Ljc2NTAwMTkgMzQuMzk5NDk2MiA1NS43NjUwMDE5Ij48L3BvbHlnb24+CiAgICAgICAgPC9nPgogICAgPC9nPgo8L3N2Zz4=" /> col_vals_not_null()
c -- ✓ 13 11
0.85		 2
0.15		 -- -- -- CSV
#4CA64C 4
col_vals_gt()
a 0 ✓ 13 13
1.00		 0
0.00		 -- -- -- --
#4CA64C66 5
col_vals_gt()
c 0 ✓ 13 11
0.85		 2
0.15		 -- -- -- CSV
#4CA64C 6
col_vals_gt()
d 0 ✓ 13 13
1.00		 0
0.00		 -- -- -- --
This technique is particularly valuable when working with wide datasets containing many similarly-structured columns or when applying standard quality checks across an entire table. It also ensures consistency in how validation rules are applied across related data columns. # Preprocessing Preprocessing (with the `pre=` parameter) allows you to transform or modify your data before applying validation checks, enabling you to validate derived or modified data without altering the original dataset: ``` python import polars as pl # Define preprocessing functions for `pre=` parameters def double_column_a(df): return df.with_columns(pl.col("a") * 2) def square_column_c(df): return df.with_columns(pl.col("c").pow(2)) ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Preprocessing validation steps via `pre=`." ) .col_vals_gt( columns="a", value=5, # Apply transformation before validation --- pre=double_column_a # Double values before checking ) .col_vals_lt( columns="c", value=100, # Apply more complex transformation --- pre=square_column_c # Square values before checking ) .interrogate() ) ```
Pointblank Validation
Preprocessing validation steps via `pre=`. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C66 1
col_vals_gt()
a 5 ✓ 13 9
0.69		 4
0.31		 -- -- -- CSV
#4CA64C66 2
E0MDYzLDMyIEwzOC43MDcwMzEsNDUuMjkyOTY5IFoiIGlkPSJsZXNzX3RoYW4iIGZpbGw9IiMwMDAwMDAiIC8+CiAgICAgICAgPC9nPgogICAgPC9nPgo8L3N2Zz4=" /> col_vals_lt()
c 100 ✓ 13 11
0.85		 2
0.15		 -- -- -- CSV
Notes

Step 1 (pre_applied) Precondition applied: no table dimension change.

Step 2 (pre_applied) Precondition applied: no table dimension change.
Preprocessing enables validation of transformed data without modifying your original dataset, making it ideal for checking derived metrics, or validating normalized values. This approach keeps your validation code clean while allowing for sophisticated data quality checks on calculated results. # Segmentation Segmentation (through the `segments=` parameter) allows you to validate data across different groups, enabling you to identify segment-specific quality issues that might be hidden in aggregate analyses: ``` python ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Segmenting validation steps via `segments=`." ) .col_vals_gt( columns="c", value=3, # Split into steps by categorical values in column 'f' --- segments="f" ) .interrogate() ) ```
Pointblank Validation
Segmenting validation steps via `segments=`. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C66 1
SEGMENT  f / high MTkgTDM5LjU4NDc2MTksMzIgTDI0LjA2OTUyMzgsMjEuMzM1MjM4MSBMMjUuMjYzODA5NSwxOS42MTcxNDI5IEw0My4yODI4NTcyLDMyIEwyNS4yNjM4MDk1LDQ0LjM4Mjg1NzEgWiIgaWQ9ImdyZWF0ZXJfdGhhbiIgZmlsbD0iIzAwMDAwMCIgLz4KICAgICAgICA8L2c+CiAgICA8L2c+Cjwvc3ZnPg==" /> col_vals_gt()
c 3 ✓ 6 2
0.33		 4
0.67		 -- -- -- CSV
#4CA64C66 2
SEGMENT  f / low col_vals_gt()
c 3 ✓ 5 4
0.80		 1
0.20		 -- -- -- CSV
#4CA64C66 3
SEGMENT  f / mid col_vals_gt()
c 3 ✓ 2 1
0.50		 1
0.50		 -- -- -- CSV
Segmentation is powerful for detecting patterns of quality issues that may exist only in specific data subsets, such as certain time periods, categories, or geographical regions. It helps ensure that all significant segments of your data meet quality standards, not just the data as a whole. # Thresholds Thresholds (set through the `thresholds=` parameter) let you set acceptable levels of failure before triggering warnings, errors, or critical notifications for individual validation steps: ``` python ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Using thresholds." ) # Add validation steps with different thresholds --- .col_vals_gt( columns="a", value=1, thresholds=pb.Thresholds(warning=0.1, error=0.2, critical=0.3) ) # Add another step with stricter thresholds --- .col_vals_lt( columns="c", value=10, thresholds=pb.Thresholds(warning=0.05, error=0.1) ) .interrogate() ) ```
Pointblank Validation
Using thresholds. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C66 1
col_vals_gt()
a 1 ✓ 13 12
0.92		 1
0.08		 ○ ○ ○ CSV
#EBBC14 2
col_vals_lt()
c 10 ✓ 13 11
0.85		 2
0.15		 ● ● -- CSV
Notes

Step 1 (local_thresholds) Step-specific thresholds set with W:0.1|E:0.2|C:0.3.

Step 2 (local_thresholds) Step-specific thresholds set with W:0.05|E:0.1.
Thresholds provide a nuanced way to monitor data quality, allowing you to set different severity levels based on the importance of each validation and your organization's tolerance for specific types of data issues. # Actions Actions (which can be configured in the `actions=` parameter) allow you to define specific responses when validation thresholds are crossed. You can use simple string messages or custom functions for more complex behavior: ``` python # Example 1: Action with a string message --- ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Using actions with a string message." ) .col_vals_gt( columns="c", value=2, thresholds=pb.Thresholds(warning=0.1, error=0.2), # Add a print-to-console action for the 'warning' threshold --- actions=pb.Actions( warning="WARNING: Values below `{value}` detected in column 'c'." ) ) .interrogate() ) ``` WARNING: Values below `2` detected in column 'c'.
Pointblank Validation
Using actions with a string message. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#EBBC14 1
col_vals_gt()
c 2 ✓ 13 10
0.77		 3
0.23		 ● ● -- CSV
Notes

Step 1 (local_thresholds) Step-specific thresholds set with W:0.1|E:0.2.
``` python # Example 2: Action with a callable function --- def custom_action(): from datetime import datetime print(f"Data quality issue found ({datetime.now()}).") ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Using actions with a callable function." ) .col_vals_gt( columns="a", value=5, thresholds=pb.Thresholds(warning=0.1, error=0.2), # Apply the function to the 'error' threshold --- actions=pb.Actions(error=custom_action) ) .interrogate() ) ``` Data quality issue found (2026-07-13 18:01:03.020794).
Pointblank Validation
Using actions with a callable function. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#EBBC14 1
col_vals_gt()
a 5 ✓ 13 3
0.23		 10
0.77		 ● ● -- CSV
Notes

Step 1 (local_thresholds) Step-specific thresholds set with W:0.1|E:0.2.
With custom action functions, you can implement sophisticated responses like sending notifications or logging to external systems. # Briefs Briefs (which can be set through the `brief=` parameter) allow you to customize descriptions associated with validation steps, making validation results more understandable to stakeholders. Briefs can be either automatically generated by setting `brief=True` or defined as custom messages for more specific explanations: ``` python ( pb.Validate( data=pb.load_dataset(dataset="small_table", tbl_type="polars"), label="Using `brief=` for displaying brief messages." ) .col_vals_gt( columns="a", value=0, # Use `True` for automatic generation of briefs --- brief=True ) .col_exists( columns=["date", "date_time"], # Add a custom brief for this validation step --- brief="Verify required date columns exist for time-series analysis" ) .interrogate() ) ```
Pointblank Validation
Using `brief=` for displaying brief messages. Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C 1
col_vals_gt()

Expect that values in a should be > 0.

 a 0 ✓ 13 13
1.00		 0
0.00		 -- -- -- --
#4CA64C 2
col_exists()

Verify required date columns exist for time-series analysis

 date -- ✓ 1 1
1.00		 0
0.00		 -- -- -- --
#4CA64C 3
col_exists()

Verify required date columns exist for time-series analysis

 date_time -- ✓ 1 1
1.00		 0
0.00		 -- -- -- --
Briefs make validation results more meaningful by providing context about why each check matters. They're particularly valuable in shared reports where stakeholders from various disciplines need to understand validation results in domain-specific terms. # Getting More Information Each validation step can be further customized and has additional options. See these pages for more information: - [Validation Methods](../../user-guide/validation-plan/validation-methods.md): A closer look at the more common validation methods - [Column Selection Patterns](../../user-guide/validation-plan/column-selection-patterns.md): Techniques for targeting specific columns - [Preprocessing](../../user-guide/validation-plan/preprocessing.md): Transform data before validation - [Segmentation](../../user-guide/validation-plan/segmentation.md): Apply validations to specific segments of your data - [Thresholds](../../user-guide/validation-plan/thresholds.md): Set quality standards and trigger severity levels - [Actions](../../user-guide/validation-plan/actions.md): Respond to threshold exceedances with notifications or custom functions - [Briefs](../../user-guide/validation-plan/briefs.md): Add context to validation steps # Conclusion Validation steps are the building blocks of data validation in Pointblank. By combining steps from different categories and leveraging common features like thresholds, actions, and preprocessing, you can create comprehensive data quality checks tailored to your specific needs. The next sections of this guide will dive deeper into each of these topics, providing detailed explanations and examples.