dataset: datasource/database/schema/robotics_events

checks:
  - schema:
      allow_extra_columns: false
      allow_other_column_order: false
  - row_count:
      threshold:
        must_be_greater_than: 0
  - freshness:
      column: ingest_time
      threshold:
        unit: hour
        must_be_less_than: 2

columns:
  - name: event_id
    data_type: string
    checks:
      - missing:
      - duplicate:
      - invalid:
          name: "Event ID length guardrail"
          valid_min_length: 1
          valid_max_length: 128
  - name: event_type
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Valid event types"
          valid_values:
            - state_change
            - cycle_complete
            - alarm_raised
            - measurement_recorded
  - name: event_time
    data_type: timestamp
    checks:
      - missing:
  - name: ingest_time
    data_type: timestamp
    checks:
      - missing:
  - name: facility_id
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Facility ID length guardrail"
          valid_min_length: 1
          valid_max_length: 64
  - name: machine_id
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Machine ID length guardrail"
          valid_min_length: 1
          valid_max_length: 64
  - name: work_unit_id
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Work Unit ID flexibility"
          valid_min_length: 1
          valid_max_length: 64
  - name: process_id
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Process ID length guardrail"
          valid_min_length: 1
          valid_max_length: 64