import pointblank as pb
def log_issue():
= pb.get_action_metadata()
metadata print(f"Type: {metadata['type']}, Step: {metadata['step']}")
= (
validation
pb.Validate(=pb.load_dataset(dataset="game_revenue", tbl_type="duckdb"),
data=pb.Thresholds(warning=0.05, error=0.10, critical=0.15),
thresholds=pb.Actions(warning=log_issue),
actions
)="player_id", pattern=r"[A-Z]{12}\d{3}")
.col_vals_regex(columns="item_revenue", value=0.05)
.col_vals_gt(columns
.col_vals_gt(="session_duration",
columns=15,
value
)
.interrogate()
)
validation
Type: col_vals_gt, Step: 2
Type: col_vals_gt, Step: 3
Pointblank Validation | |||||||||||||
2025-04-15|14:44:24 DuckDBWARNING0.05ERROR0.1CRITICAL0.15 |
|||||||||||||
STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | E | C | EXT | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
#4CA64C | 1 |
col_vals_regex()
|
✓ | 2000 | 2000 1.00 |
0 0.00 |
○ | ○ | ○ | — | |||
#EBBC14 | 2 |
col_vals_gt()
|
✓ | 2000 | 1701 0.85 |
299 0.15 |
● | ● | ○ | — | |||
#FF3300 | 3 |
col_vals_gt()
|
✓ | 2000 | 1675 0.84 |
325 0.16 |
● | ● | ● | — | |||
2025-04-15 14:44:24 UTC< 1 s2025-04-15 14:44:24 UTC |