MAQ Software

Data Validator - Feature Summary The 'Data Validator' is a solution designed to ensure high data quality across source and destination systems through a flexible, rule-driven approach. It empowers teams to define, execute, monitor, and audit various types of data validation checks seamlessly. Key Features Test Types Supported: Row Count Check: Validates if row counts between source and target tables are within a ±5% tolerance.

Grain Check: Ensures the uniqueness of primary keys across both source and destination tables. KPI Check: Compares the results of custom KPI SQL logic or aggregated column values between the source and destination. Passes if the difference is within ±5%.

Scheduling Support: Test cases are scheduled using Snowflake tasks for automatic execution. Offers full CRON-style configuration with time zone support. Automatically log results, including comparison values, pass/fail status, and metadata for analysis in dashboards or the "Show Test Cases" view.

, databases, tables, columns, SQL queries). Show Test Cases: Displays existing test cases based on selected filters like table type and test type. Execute Test Case: On-demand Execution of test cases.

View Test Results: Offers detailed visibility into execution status, timestamps, result IDs, and pass/fail outcomes, enabling historical trend analysis. Schedule Test Cases: Allows to setup a customized schedule to run the checks automatically.