Pointblank is a data validation toolkit for assessing and monitoring the quality of tabular data. It helps analysts, data engineers and researchers determine whether datasets meet expected requirements and identify problems that could affect subsequent analysis or processing.
The toolkit provides a readable, chainable interface for defining validation plans. Checks can be combined into repeatable workflows, making it easier to apply consistent quality standards across datasets and projects.
Pointblank places particular emphasis on communicating validation results. Its reporting facilities help developers investigate failures while presenting data quality findings in a format that can be understood by colleagues and other stakeholders.
This is free and open source software.
Key Features
- Define validation plans through a chainable interface that combines multiple checks.
- Validate column values against numeric ranges, regular expressions and permitted value sets.
- Identify missing values, unexpected nulls and duplicate records.
- Check column existence, column counts and table row counts.
- Apply custom expressions and combined conditions to enforce complex business rules.
- Configure warning, error and critical thresholds according to the proportion of failed checks.
- Trigger actions and notifications when validation thresholds are exceeded.
- Generate interactive, customisable reports with detailed validation results.
- Extract failing records and filter datasets using the results of individual checks.
- Work with Pandas, Polars, DuckDB, SQLite, PostgreSQL, MySQL and other supported data sources.
- Define reusable validation workflows using YAML configuration files.
- Run data inspections and validation checks through a command-line interface.
- Generate synthetic datasets for testing and experimenting with validation rules.
- Optionally draft validation plans using AI-assisted analysis of datasets.
- Cross-platform support – runs on Linux, macOS, and Windows.
Website: github.com/posit-dev/pointblank
Support:
Developer: Posit Software, PBC / Richard Iannone
License: MIT License
Pointblank is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| Python Data Validation | |
|---|---|
| Pydantic | Data validation using Python type hints |
| pandera | Framework for precision data testing |
| jsonschema | Implementation of JSON Schema for Python |
| Cerberus | Lightweight and extensible data validation library |
| schema | Library for validating Python data structures |
| GX | Validating, documenting, and profiling data |
| marshmallow | ORM/ODM/framework-agnostic library |
| Voluptuous | Python data validation library |
| Schematics | Combine types into structures, validate , and transform the shapes of data |
| Colander | Serialization / deserialization / validation library |
| Valideer | Lightweight data validation and adaptation Python library |
| OpenRefine | Desktop program for data cleanup and transformation |
| Soda Core | Data quality and data contract verification engine |
| OpenMetadata | Unified metadata platform |
| Elementary OSS | dbt-native data observability command-line tool |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.