variables:
  ASSET_NAME:
    default: "offer_snapshots"
  ASSET_TYPE:
    default: "merchant_offer_feed"
  BUSINESS_DOMAIN:
    default: "Offers"
  OWNER_TEAM:
    default: "Pricing Team"
  ONCALL_ROUTE:
    default: "#pricing-support"
  DATA_DICTIONARY_REFS:
    default: |
      offer_id -> dict.offer_id.v3
      price -> dict.price.v2
  STORAGE_LOCATION_BASE_PATH:
    default: "s3://idealo-offers/state/"
  PARTITIONING_SPEC:
    default: "date_utc, country"
  SLA_DUE_TIMES:
    default: "00:15 UTC daily"
  PRIMARY_KEYS_AND_UNIQUENESS:
    default: "offer_id, date_utc"
  SCHEMA_SPEC:
    default: "offer_id: string, date_utc: string, price: float, currency: string, availability_status: string"
  CONSTRAINTS_AND_ENUMS:
    default: "price >= 0, currency IN (USD, EUR, GBP), availability_status IN (in_stock, out_of_stock, preorder, unknown)"
  FRESHNESS_AND_COMPLETENESS_EXPECTATIONS:
    default: "≥90% of active merchants present by SLA due"
    
checks:
  - schema:
      allow_extra_columns: false
      allow_other_column_order: false
  - row_count:
      threshold:
        must_be_greater_than: 0
  - failed_rows:
      name: "Ensure primary keys are unique"
      qualifier: pk_uniqueness
      query: |
        SELECT offer_id, date_utc
        FROM datasource.database.schema.offer_snapshots
        GROUP BY offer_id, date_utc
        HAVING COUNT(*) > 1
      threshold:
        must_be: 0
  - freshness:
      column: date_utc
      threshold:
        unit: hour
        must_be_less_than: 24