label: "Apple Music Pitch Grid"
connection: "snowflake_via_lookerappadmin"

include: "dt_apple_music_pitch_grid.view.lkml"
include: "dt_deliverable_from_release.view.lkml"
include: "dt_marketing_change_log.view.lkml"
include: "int_prod_vw_restrictions_release_substore.view.lkml"
include: "int_prod_vw_restrictions_release_territory.view.lkml"
include: "int_prod_apg_apple_pitch_grid.view.lkml"
include: "dt_flatten_marketing_info.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "orch_app_ar_focus_track.view.lkml"
include: "int_dbt_prod_apple_music_pitch_grid_specialist_genres.view.lkml"

explore: dt_apple_music_pitch_grid {
  label: "Apple Music Pitch Grid"
  view_label: "Apple Music Pitch Grid"
  hidden: yes
  case_sensitive: no

  join: dt_deliverable_from_release {
    view_label: "Release Is Deliverable"
    sql_on: ${dt_apple_music_pitch_grid.release_id} = ${dt_deliverable_from_release.release_id} ;;
    relationship: one_to_one
  }

  join: dt_marketing_change_log {
    view_label: "Marketing Change Log"
    sql_on: ${dt_apple_music_pitch_grid.release_id} =  ${dt_marketing_change_log.release_id};;
    relationship: one_to_many
    fields: [action_taken, update_to, update_timestamp, value, values_aggregated]

  }

  join: int_prod_vw_restrictions_release_substore {
    view_label: "Restrictions"
    sql_on: ${int_prod_vw_restrictions_release_substore.release_id}=${dt_apple_music_pitch_grid.release_id} ;;
    relationship: one_to_many
  }

  join: int_prod_vw_restrictions_release_territory {
    view_label: "Restrictions"
    sql_on: ${int_prod_vw_restrictions_release_territory.release_id}=${dt_apple_music_pitch_grid.release_id} ;;
    relationship: one_to_many
  }

  join: dt_flatten_marketing_info {
    view_label: "Marketing Info"
    relationship: one_to_one
    sql_on: ${dt_flatten_marketing_info.release_id} = ${dt_apple_music_pitch_grid.release_id} ;;
  }

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${dt_apple_music_pitch_grid.label_id} = ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
  }

  join: orch_app_ar_focus_track {
    view_label: "Pitch Info"
    relationship: one_to_many
    sql_on: ${dt_apple_music_pitch_grid.release_id} = ${orch_app_ar_focus_track.release_id} ;;
  }

 }

explore: int_dbt_prod_apple_music_pitch_grid_specialist_genres {
  label: "Apple Music Pitch Grid Specialist Genres"
  view_label: "Apple Music Pitch Grid"
  hidden: yes
  case_sensitive: no

  join: dt_deliverable_from_release {
    view_label: "Release Is Deliverable"
    sql_on: ${int_dbt_prod_apple_music_pitch_grid_specialist_genres.release_id} = ${dt_deliverable_from_release.release_id} ;;
    relationship: one_to_one
  }

  join: dt_marketing_change_log {
    view_label: "Marketing Change Log"
    sql_on: ${int_dbt_prod_apple_music_pitch_grid_specialist_genres.release_id} =  ${dt_marketing_change_log.release_id};;
    relationship: one_to_many
    fields: [action_taken, update_to, update_timestamp, value, values_aggregated]

  }

  join: int_prod_vw_restrictions_release_substore {
    view_label: "Restrictions"
    sql_on: ${int_prod_vw_restrictions_release_substore.release_id}=${int_dbt_prod_apple_music_pitch_grid_specialist_genres.release_id} ;;
    relationship: one_to_many
  }

  join: int_prod_vw_restrictions_release_territory {
    view_label: "Restrictions"
    sql_on: ${int_prod_vw_restrictions_release_territory.release_id}=${int_dbt_prod_apple_music_pitch_grid_specialist_genres.release_id} ;;
    relationship: one_to_many
  }

  join: dt_flatten_marketing_info {
    view_label: "Marketing Info"
    relationship: one_to_one
    sql_on: ${dt_flatten_marketing_info.release_id} = ${int_dbt_prod_apple_music_pitch_grid_specialist_genres.release_id} ;;
  }

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_apple_music_pitch_grid_specialist_genres.label_id} = ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
  }

  join: orch_app_ar_focus_track {
    view_label: "Pitch Info"
    relationship: one_to_many
    sql_on: ${int_dbt_prod_apple_music_pitch_grid_specialist_genres.release_id} = ${orch_app_ar_focus_track.release_id} ;;
  }
}

explore: int_prod_apg_apple_pitch_grid {
    label: "Apple Music Pitch Grid V2"
    view_label: "Apple Music Pitch Grid"
    hidden: yes
    case_sensitive: no

    join: dt_deliverable_from_release {
      view_label: "Release Is Deliverable"
      sql_on: ${int_prod_apg_apple_pitch_grid.release_id} = ${dt_deliverable_from_release.release_id} ;;
      relationship: one_to_one
    }

    join: dt_marketing_change_log {
      view_label: "Marketing Change Log"
      sql_on: ${int_prod_apg_apple_pitch_grid.release_id} =  ${dt_marketing_change_log.release_id};;
      relationship: one_to_many
      fields: [action_taken, update_to, update_timestamp, value, values_aggregated]

    }

    join: int_prod_vw_restrictions_release_substore {
      view_label: "Restrictions"
      sql_on: ${int_prod_vw_restrictions_release_substore.release_id}=${int_prod_apg_apple_pitch_grid.release_id} ;;
      relationship: one_to_many
    }

    join: int_prod_vw_restrictions_release_territory {
      view_label: "Restrictions"
      sql_on: ${int_prod_vw_restrictions_release_territory.release_id}=${int_prod_apg_apple_pitch_grid.release_id} ;;
      relationship: one_to_many
    }

}