version: 2

sources:
  - name: snapshots
    schema: 'snapshots'
    database: gcp-digital-bi
    tables:
      - name: dws_hr_employees_departments_basic_info_v2_daily_snapshot

snapshots:
   - name: dp
     dws_hr_employees_departments_basic_info_v2_daily_snapshot:
       unique_key: id
       strategy: check
       check_cols: ['name', 'email', 'area_email_group', 'active', 'first_department_name', 'second_department_name', 'third_department_name', 'fourth_department_name', 'job_title', 'main_department_name', 'cost_center']

snapshot-paths:
  - models/dp  # 添加 models/dp 目录作为一个快照路径
  - snapshots  # 保留默认的 snapshot 目录作为另一个快照路径