Demo

Here's the demo tests of a demo user database I'm planning to build:

run_results - all of this is in a single flat table, I'm showing this looking hierarchical just to show the different sets of columns that will all be in this table. - static data: instance_name database_name table_name table_partitioned - true, false check_name check_policy_type - quality, data-management, security, etc check_type - rule or profile(?) check_config - run data: run_start_timestamp run_mode - incremental - run table data: partition key partition value - run check data: run_check_start_timestamp run_check_end_timestamp run_check_mode - incremental or full run_check_rc run_check_violation_cnt run_check_anomaly_score - 0 to 100 run_check_severity_score - 0 to 100 - annotation data validated - True, False

Hypothetical database being checked:

- instance names:
    prod
    prod-failover
    staging
    test
- database names:
    westwind
- table names:
    customers
        - cols:
            cust_id
            cust_name
            cust_type
        - checks:
    assets
        - cols:
            asset_id
            cust_id
            asset_type
    asset_events
        - cols:
            cust_id
            asset_id
            event_type
    event_type
        - cols:
            event_type_id
            event_type_name
    asset_type
        - cols:
            asset_type_id
            asset_type_name
    cust_type
        - cols:
            cust_type_id
            cust_type_name