dataset: datasource/database/schema/bank_accounts

variables:
  CONTRACT_NAME:
    default: "bank_account_information"
  SCHEMA_VERSION:
    default: "1"
  DATA_OWNER_TEAM:
    default: "Bank Data Team"

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

columns:
  - name: bank_account_id
    data_type: string
    checks:
      - missing:
      - duplicate:
      - invalid:
          name: "Bank Account ID length guardrail"
          valid_min_length: 5
          valid_max_length: 20
  - name: event_time
    data_type: timestamp
    checks:
      - missing:
  - name: schema_version
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Valid schema versions"
          valid_values:
            - "1"
            - "2"
  - name: contract_name
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Contract Name must match"
          valid_values:
            - bank_account_information
  - name: data_owner_team
    data_type: string
    checks:
      - missing:
      - invalid:
          name: "Owner Team must be valid"
          valid_values:
            - Bank Data Team
  - name: account_balance
    data_type: float
    checks:
      - invalid:
          name: "Reasonable account balance range"
          valid_min: -1000000
          valid_max: 1000000
  - name: account_holder_name
    data_type: string
    checks:
      - invalid:
          name: "Account Holder Name guardrail"
          valid_min_length: 1
          valid_max_length: 128