Solutions

Advanced Rules

As data ecosystems evolve, most enterprises have a need to graduate from basic data checks to advanced business logic checks. Asserting business logic at point of data ingress / egress is crucial to ensure that critical business processes are intact.

Qualytics enables users to author advanced logic directly as data quality checks, significantly reducing complexity typically associated with such rules.

Time Series Anomaly Detection

Want to convert your numeric value to a time series value and track its acceptable ranges over time? Using Metric Checks, you can enable any fractional / integer value to be tracked over time – not only for static checks, but also for dynamic checks that utilize previously observed values.

Aggregation Comparison

There are often use cases where users need to compare results of two disparate queries from two tables (from one or two databases) to each other. A simple example would be to compare counts from a bronze to silver layer of medallion architecture in order to ensure that data pipelines have executed correctly. A more complex example would be to run SQL queries joining multiple tables to produce a calculation for business logic equivalence across databases. Using Aggregation Comparison checks, you can easily plug in any SQL query on either side of the desired aggregations and run comparisons.

Lookups

Referential Integrity is a major pain in data quality. We don’t mean just for keys – users want the ability to utilize reference tables, often in other databases, to ensure a value is acceptable against or unique compared to the reference values. Exists In and Not Exists In checks enable users to run referential integrity and uniqueness checks across databases.

Pretrained AI Models

There are often pretrained AI models available in public repositories that deliver tremendous value – for instance libpostal is a great pretrained library for address validation that is trained on 2B+ real addresses. However, embedding such a library into your data pipelines and workflows introduces complexity and labor that impacts operationalization. Qualytics has the ability to embed such models directly into our platform: for instance, all of libpostal’s power is available through our is Address check type.

Protect the data your business runs on.