Data reliability tool for profiling and testing your data
Docs | Roadmap | Discord | Blog
Data Reliability = Profiling + Testing
Piperider is a CLI tool that allows you to build data profiles and write assertion tests for easily evaluating and tracking your data's reliability over time.
Core Concepts
- Profile Your Data to explore/understand what kind of dataset you're dealing with e.g. completeness, duplicates, missing values, distributions
- Test Your Data to verify that your data is within acceptable range and formatted correctly
- Observe & Monitor Your Data to keep an eye on how that data changes over time
Key Features
- SQL-based (additionally supports CSV)
- Data Profiling Characteristics
- Provides rich data profiling metrics
- e.g.
missing,uniqueness,duplicate_rows,quantiles,histogram
- Test datasets with a mix of custom and built-in assertion definitions
- Auto-generates recommended assertions based on your single-run profiles
- Generates single-run reports to visualize your data profile and assertion test results (example)
- Generates comparison reports to visualize how your data has changed over time (example)
- Supported Datasources: Snowflake, BigQuery, Redshift, Postgres, SQLite, DuckDB, CSV, Parquet.
Quickstart
Installation
pip install piperider
By default, PipeRider supports built-in SQLite connector, extra connectors are available:
| connectors | install |
|---|---|
| snowflake | pip install 'piperider[snowflake]' |
| postgres | pip install 'piperider[postgres]' |
| bigquery | pip install 'piperider[bigquery]' |
| redshift | pip install 'piperider[redshift]' |
| parquet | pip install 'piperider[parquet]' |
| csv | pip install 'piperider[csv]' |
| duckdb | pip install 'piperider[duckdb]' |
Use comma to install multiple connectors in one line:
pip install 'piperider[postgres,snowflake]'
Initialize Project & Diagnose Settings
Once installed, initialize a new project with the following command.
piperider init # initializes project config
piperider diagnose # verifies your data source connection & project config
Profiling and Testing Your Data
Next, execute piperider run, which will do a number of things:
- Create a single-run profile of your data source
- Auto-generate recommended or template assertions files (first-run only)
- Test that single-run profile against any available assertions, including custom and/or recommended assertions
- Generate a static HTML report, which helps visualize the single-run profile and its assertion results.
Common Usages/Tips:
piperider run # profile all tables in the data source.
piperider run --table $TABLENAME # profile a specific table
piperider generate-report -o $PATHNAME # Specify the output location of the generated report
piperider generate-assertions # To re-generate the recommended assertions after the first-run
Comparing Your Data Profiles
With at least two runs completed, you can then run piperider compare-reports, which will generate a comparison report that presents the changes between them (e.g. schema changes, column renaming, distributions).
Common Usages/Tips:
piperider compare-reports --last # Compare the last two reports automatically using
For more details on the generated report, see the doc
Example Report Demo
See Generated Single-Run Report
Development
See setup dev environment and the contributing guildlines to get started.
We're in an early stage, so let us know if you have any questions, feedback, or need help trying out PipeRider! ❤️
1 maintainer
Metadata
1 maintainer
Release files for piperider-nightly 0.18.0.20230201
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| piperider-nightly-0.18.0.20230201.tar.gz | 3.6 MB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| piperider_nightly-0.18.0.20230201-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 7.3 MB
Release files / piperider-nightly-0.18.0.20230201.tar.gz
| Download URL | piperider-nightly-0.18.0.20230201.tar.gz |
|---|---|
| Size | 3.6 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e60ca4e6ecb8284411ea9c3cda420bc30a9921c4583705bed9efa994376b13be
|
|
BLAKE2b-256 checksum How to use checksums |
bd3478e1fe9584fea9bcf8cfdf99d79b0f5ce5605ae6cb184d5cdda75fe5d578
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.8.16
|
Release files / piperider_nightly-0.18.0.20230201-py3-none-any.whl
| Download URL | piperider_nightly-0.18.0.20230201-py3-none-any.whl |
|---|---|
| Size | 3.7 MB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
b3bfdbcb61888c6c0ba3f1f02f1d28353dd0417ae3bcba1b8b28c62d6b8e1630
|
|
BLAKE2b-256 checksum How to use checksums |
0b2df20d2441f731f520cb1aa339e0c0e68c1ff586eb688c8c05e515a39ef44a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.8.16
|
