connection: "snowflake_via_lookerappadmin"

include: "/views/apple_financial_reports/*.view.lkml"
include: "/views/youtube_financial_reports/*.view.lkml"

explore: facts_prod_staging_raw_apple_music_footer {
  hidden:  yes
  label: "Apple Music Footer"
  view_label: "Apple Music Financial Reports"

  join: int_dbt_prod_seed_data_apple_vendor_map {
    view_label: "Apple Vendor"
    relationship: many_to_one
    sql_on: ${facts_prod_staging_raw_apple_music_footer.vendor_id} = ${int_dbt_prod_seed_data_apple_vendor_map.distributor_id} ;;
  }

}

explore: facts_prod_staging_raw_apple_music_linear_radio_service {
  hidden:  yes
  label: "Apple Music Linear radio Service"
  view_label: "Apple Music Financial Reports"

  join: int_dbt_prod_seed_data_apple_vendor_map {
    view_label: "Apple Vendor"
    relationship: many_to_one
    sql_on: ${facts_prod_staging_raw_apple_music_linear_radio_service.vendor_id} = ${int_dbt_prod_seed_data_apple_vendor_map.distributor_id} ;;
  }

}

explore: facts_prod_staging_raw_apple_music_royalty_calculation {
  hidden:  yes
  label: "Apple Music Royalty Calculation"
  view_label: "Apple Music Financial Reports"

  join: int_dbt_prod_seed_data_apple_vendor_map {
    view_label: "Apple Vendor"
    relationship: many_to_one
    sql_on: ${facts_prod_staging_raw_apple_music_royalty_calculation.vendor_id} = ${int_dbt_prod_seed_data_apple_vendor_map.distributor_id} ;;
  }

}

explore: facts_prod_staging_raw_apple_music_summary {
  hidden:  yes
  label: "Apple Music Summary"
  view_label: "Apple Music Financial Reports"

  join: int_dbt_prod_seed_data_apple_vendor_map {
    view_label: "Apple Vendor"
    relationship: many_to_one
    sql_on: ${facts_prod_staging_raw_apple_music_summary.vendor_id} = ${int_dbt_prod_seed_data_apple_vendor_map.distributor_id} ;;
  }

}

explore: facts_prod_staging_raw_youtube_monthly_red_label_music_summary {
  hidden:  yes
  label: "SVOD Music Summary"
  view_label: "YouTube Financial Reports"
  }

explore: facts_prod_staging_raw_youtube_monthly_red_label_non_music_summary {
  hidden:  yes
  label: "SVOD Non-Music Summary"
  view_label: "YouTube Financial Reports"
}

explore: facts_prod_staging_raw_youtube_monthly_red_label_subscriber_summary {
  hidden:  yes
  label: "SVOD Subscriber Summary"
  view_label: "YouTube Financial Reports"
}

explore: facts_prod_staging_raw_youtube_monthly_report_v1_0_summary {
  hidden:  yes
  label: "AVOD Summary"
  view_label: "YouTube Financial Reports"
}

explore: facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_country {
  hidden:  yes
  label: "AVOD Summary by Country"
  view_label: "YouTube Financial Reports"
}

explore: facts_prod_staging_raw_youtube_monthly_report_v1_0_summary_by_day {
  hidden:  yes
  label: "AVOD Summary by Day"
  view_label: "YouTube Financial Reports"
}