dataset: wethebestgrowth/postgres/soda_demo_data/retail_orders
checks:
  - schema: {}
  - freshness:
      column: created_at
      threshold:
        unit: hour
        must_be_less_than_or_equal: 24
columns:
  - name: order_id
    data_type: character varying
    checks:
      - missing:
          name: No missing value
  - name: product_id
    data_type: character varying
    checks:
      - missing:
          name: No missing values
  - name: customer_id
    data_type: character varying
    checks:
      - missing:
          name: No missing values
  - name: order_quantity
    data_type: integer
    checks:
      - invalid:
          name: No negative values
          valid_min: 0
  - name: discount
    data_type: double precision
    checks:
      - invalid:
          name: No negative values
          valid_min: 0
  - name: discount_currency
    data_type: character varying
  - name: billing_address
    data_type: character varying
  - name: shipping_address
    data_type: character varying
  - name: payment_method
    data_type: character varying
  - name: order_date
    data_type: timestamp without time zone
  - name: ship_date
    data_type: timestamp without time zone
  - name: country_code
    data_type: character varying
  - name: total_order_value
    data_type: double precision
  - name: created_at
    data_type: timestamp without time zone