product.yml

gistfile1.txt

table_name: product
samples:
  table_limit: 50
  failed_limit: 50
metrics:
  - row_count
  - missing_count
  - missing_percentage
  - values_count
  - values_percentage
  - valid_count
  - valid_percentage
  - invalid_count
  - invalid_percentage
  - min_length
  - max_length
  - avg_length
  - min
  - max
  - avg
  - sum
  - variance
  - stddev
  - histogram
  - uniqueness
tests:
  - row_count > 0
columns:
  productid:
    valid_format: uuid
    tests:
      - invalid_percentage == 0
  productcategory:
    tests:
      - missing_count < 10
  size:
    valid_max: 95
    tests:
      - invalid_percentage < 5
sql_metrics:
  - type: failed_rows
    name: INVALID_PRICE
    sql: |
            select * from product
            where purchaseprice > sellingprice