{% if youtubereporting_aggregations %}
- args:
    dbx_job_id: {{ dbx_job_id_conversion }}
    dbx_spark_params: {{ dbx_spark_params_conversion }}
    dbx_job_max_lifetime: {{ yt_active_claims_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: active_claims_conversion
    unit_type: snapshot
    valid_from: '2020-02-15'
    days_offset: 2
  dependencies:
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-active_claims-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-active_claims_conversion
- args:
    dbx_job_id: {{ dbx_job_id_conversion }}
    dbx_spark_params: {{ dbx_spark_params_conversion }}
    dbx_job_max_lifetime: {{ default_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: content_owner_asset_conversion
    unit_type: weekly
    valid_from: '2020-01-01'
    days_offset: 0
  dependencies:
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-content_owner_asset-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  frequency: '0 0 * * 7'
  unit_of_work: youtubereporting-{yyyymmdd}-content_owner_asset_conversion
- args:
    dbx_job_id: {{ dbx_job_id_conversion }}
    dbx_spark_params: {{ dbx_spark_params_conversion }}
    dbx_job_max_lifetime: {{ yt_content_owner_asset_traffic_source_conv_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: content_owner_asset_traffic_source_conversion
    unit_type: daily
    valid_from: '2020-01-01'
    valid_until: '2023-11-01'
    days_offset: 2
  dependencies:
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-content_owner_asset_traffic_source-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-content_owner_asset_traffic_source_conversion
- args:
    dbx_job_id: {{ dbx_job_id_conversion }}
    dbx_spark_params: {{ dbx_spark_params_conversion }}
    dbx_job_max_lifetime: {{ yt_content_owner_traffic_source_conv_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: content_owner_traffic_source_conversion
    unit_type: daily
    valid_from: '2020-01-01'
    valid_until: '2023-11-01'
    days_offset: 2
  dependencies:
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-content_owner_traffic_source-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-content_owner_traffic_source_conversion
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_streams_video_id_date_day }}
    dbx_job_max_lifetime: {{ default_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: streams_video_id_date_day
    unit_type: daily
    valid_from: '2020-01-13'
    days_offset: 2
  dependencies:
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_basic-a3
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-streams_video_id_date_day
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_demographics_video_id_date_day }}
    dbx_job_max_lifetime: {{ default_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: demographics_video_id_date_day
    unit_type: daily
    valid_from: '2020-01-13'
    days_offset: 2
  dependencies:
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_demographics-a1
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-demographics_video_id_date_day
- args:
    dbx_job_id: {{ dbx_job_id_youtube_metadata }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_metadata }}
    dbx_job_max_lifetime: {{ yt_active_claims_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: metadata
    unit_type: snapshot
    valid_from: '2020-02-15'
    days_offset: 2
  dependencies:
  - name: youtubereporting-{yyyymmdd}-active_claims_conversion
    type: etl_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-active_claims-a3
    type: slz_uow
  - name: vevo-{yyyymmdd}-metadata
    type: etl_in_progress
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-metadata
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_streams_isrc_date_day }}
    dbx_job_max_lifetime: {{ double_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: streams_isrc_date_day
    unit_type: daily
    valid_from: '2020-01-13'
    days_offset: 2
  dependencies:
  {% if youtubereporting_streams_isrc_date_day_sf__v_yt_video_isrc %}
  - name: V_YT_VIDEO_ISRC
    type: snowflake
    days_offset: 2
  {% endif %}
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_basic-a3
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-streams_isrc_date_day
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_demographics_isrc_date_day }}
    dbx_job_max_lifetime: {{ double_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: demographics_isrc_date_day
    unit_type: daily
    valid_from: '2020-01-13'
    days_offset: 2
  dependencies:
  {% if youtubereporting_demographics_isrc_date_day_sf__v_yt_video_isrc %}
  - name: V_YT_VIDEO_ISRC
    type: snowflake
    days_offset: 2
  {% endif %}
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_demographics-a1
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-demographics_isrc_date_day
{% if youtubereporting_ugc_aggregations %}
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_streams_productfamily_content_date_day }}
    dbx_job_max_lifetime: {{ double_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: streams_productfamily_content_date_day
    unit_type: daily
    valid_from: '2019-11-15'
    days_offset: 2
  dependencies:
  {% if youtubereporting_aggregations_video_product_family_dep %}
  - name: V_YT_VIDEO_PRODUCT_FAMILY
    type: snowflake
    days_offset: 2
  {% endif %}
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_basic-a3
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-streams_productfamily_content_date_day
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_demographics_productfamily_content_date_day }}
    dbx_job_max_lifetime: {{ double_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: demographics_productfamily_content_date_day
    unit_type: daily
    valid_from: '2019-11-15'
    days_offset: 2
  dependencies:
  {% if youtubereporting_aggregations_video_product_family_dep %}
  - name: V_YT_VIDEO_PRODUCT_FAMILY
    type: snowflake
    days_offset: 2
  {% endif %}
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_demographics-a1
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-demographics_productfamily_content_date_day
{% endif %}
{% if youtube_project_aggregations %}
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_streams_project_date_day }}
    dbx_job_max_lifetime: {{ double_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: streams_project_date_day
    unit_type: daily
    valid_from: '2019-11-15'
    days_offset: 2
  dependencies:
  {% if youtubereporting_streams_project_content_date_day_sf__v_yt_video_isrc %}
  - name: V_YT_VIDEO_ISRC
    type: snowflake
    days_offset: 2
  {% endif %}
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_basic-a3
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-streams_project_content_date_day
- args:
    dbx_job_id: {{ dbx_job_id_youtubereporting }}
    dbx_spark_params: {{ dbx_spark_params_youtubereporting_demographics_project_date_day }}
    dbx_job_max_lifetime: {{ double_dbx_job_max_lifetime }}
    dsp: youtubereporting
    report_type: demographics_project_date_day
    unit_type: daily
    valid_from: '2019-11-15'
    days_offset: 2
  dependencies:
  {% if youtubereporting_demographics_project_date_day_sf__v_yt_video_isrc %}
  - name: V_YT_VIDEO_ISRC
    type: snowflake
    days_offset: 2
  {% endif %}
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_demographics-a1
    type: slz_uow
  - is_single_context: true
    name: youtubereporting-{yyyymmdd}-sme-asset_combined-a3
    type: slz_uow
  data_source: 'slz'
  schedule: '*/10 * * * *'
  unit_of_work: youtubereporting-{yyyymmdd}-demographics_project_content_date_day
{% endif %}
{% endif %}