job.yml

version: 1

account_id: 7108
project_name: svp
project_id: 34748

environments:
  - name: Airflow-SVP Production
    id: 43528
    dbt_version: 1.3.4
    custom_branch: release

    jobs:
      - name: airflow_da_address_match_prd
        id: 103334
        steps:
          - dbt test --select source:da_address_match
          - dbt build --select tag:da_address_match --exclude tag:unit-test
        tracking: true
        schedule: daily
      
      - name: airflow_paf_prd
        id: 40879
        steps:
          - dbt test --select tag:paf_source
          - dbt build --select tag:paf --exclude svp_apm_property_id_mapping
        tracking: true
        schedule: monthly
      
      - name: airflow_vg_prd
        id: 44393
        steps:
          - dbt test --select tag:vg_source
          - dbt build --select tag:vg+ --exclude svp_apm_property_id_mapping
        tracking: true
        schedule: weekly
      
      - name: airflow_psma_prd
        id: 93798
        steps:
          - dbt test --select tag:psma_source
          - dbt build --select tag:psma --exclude svp_apm_property_id_mapping --indirect-selection=buildable
        tracking: true
        schedule: quarterly
      
      - name: airflow_prd_export_hpg_property_activity_update_rent
        id: 139376
        steps:
          - dbt run --select hpg_api_json_property_activity_update_rent
        tracking: true
        schedule: daily

      - name: airflow_prd_export_hpg_property_activity_delete_rent
        id: 146029
        steps:
          - dbt run --select hpg_api_json_property_activity_delete_rent
          - "dbt run-operation unload_svp_to_s3_json --args '{product: hpg, json_model: hpg_api_json_property_activity_delete_rent, s3_dir: uploads}'"
        tracking: true
        schedule: daily

      - name: airflow_prd_hpg_profile_activity
        id: 141767
        steps:
          - dbt seed --select svp_column_mapping --full-refresh
          - dbt build --select +hpg_property_profile,tag:daily +hpg_property_activity,tag:daily --exclude svp_apm_property_id_mapping
        tracking: true
        schedule: daily

      - name: svp_grs_release_prd
        id: 95195
        steps:
          - dbt build --select mart.grs
        tracking: true
        schedule: monthly