connection: "snowflake-looker-external"

include: "/views/Black17/int_dbt_prod_black17_summary_streams.view.lkml"
include: "/facts_prod_dim_playlist.view.lkml"
include: "/facts_prod_dim_label.view.lkml"
include: "/views/Facts/facts_prod_dim_country.view.lkml"
include: "/facts_prod_dim_release.view.lkml"
include: "/facts_prod_dim_track.view.lkml"
include: "/facts_prod_dim_artist.view.lkml"
include: "/orch_app_ar_releases.view.lkml"
include: "/orch_app_ar_country.view.lkml"
# include: "/orch_app_ar_genre.view.lkml"
include: "/metadata_simplified.view.lkml"
include: "/int_dbt_prod_awal_tier_groups.view.lkml"
include: "/orch_app_ar_vendor.view.lkml"
include: "/orch_app_ar_subaccount.view.lkml"
include: "/orch_app_ar_orchadmin_users.view.lkml"
# include: "orch_app_ar_release_subgenre.view.lkml"
# include: "orch_app_ar_subgenre.view.lkml"
# include: "orch_app_ar_product_type.view.lkml"
# include: "orch_app_ar_mkt_priority.view.lkml"
# include: "dt_flatten_marketing_info.view.lkml"
# include: "dt_flatten_country_region.view.lkml"
include: "/orch_app_ar_track.view.lkml"
# include: "orch_app_ar_language.view.lkml"
include: "/int_dbt_prod_product_manager_mapping_union.view.lkml"
# include: "int_prod_vw_deleted_releases.view"

week_start_day: friday

fiscal_month_offset: -9

explore: metadata_simplified {
  hidden: yes
}

explore: int_dbt_prod_black17_summary_streams {
  label: "Summary Streams Model"
  case_sensitive: no
  hidden: yes
  # sql_always_where: ${int_dbt_prod_black17_summary_streams.label_id} != 32551 ;;

  join: orch_app_ar_releases {
    view_label: "Release"
    relationship: one_to_one
    sql_on: ${int_dbt_prod_black17_summary_streams.upc} = to_varchar(${orch_app_ar_releases.upc}) ;;
    fields: [
      format,
      release_name,
      release_date,release_week,release_month,release_year
    ]

  }
  # join: orch_app_ar_product_type {
  #   view_label: "Release"
  #   relationship: many_to_one
  #   sql_on: ${orch_app_ar_releases.product_type_id} = ${orch_app_ar_product_type.product_type_id} ;;
  # }
  join: orch_app_ar_subaccount {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.subaccount_id} = (${orch_app_ar_subaccount.subaccount_id}) ;;
    fields: [subaccount_name, orch_app_ar_subaccount.subaccount_id]
  }

  join: facts_prod_dim_playlist {
    view_label: "Playlist"
    sql_on: ${int_dbt_prod_black17_summary_streams.source_uri} = ${facts_prod_dim_playlist.playlisturi} and LOWER(${int_dbt_prod_black17_summary_streams.source_of_stream_original}) = LOWER(${facts_prod_dim_playlist.playlisttypename});;
    relationship: many_to_one
    fields: []
  }

  join: facts_prod_dim_release {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_black17_summary_streams.upc} = to_varchar(${facts_prod_dim_release.upc}) ;;
    fields: []
  }

  join: facts_prod_dim_track {
    view_label: "Track"
    relationship: many_to_one
    sql_on: to_varchar(${int_dbt_prod_black17_summary_streams.isrc}) = to_varchar(${facts_prod_dim_track.isrc})
      and ${int_dbt_prod_black17_summary_streams.upc} =  to_varchar(${facts_prod_dim_track.upc});;
    fields: [
      track_name
    ]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_one
    sql_on: ${facts_prod_dim_track.track_unique_id} = ${orch_app_ar_track.tuid} ;;
    fields: [track_version]
  }

  # join: orch_app_ar_language {
  #   view_label: "Track"
  #   relationship: many_to_one
  #   sql_on: ${orch_app_ar_track.meta_language}=${orch_app_ar_language.language_code} ;;
  #   fields: [language]
  # }

  join: facts_prod_dim_artist {
    view_label: "Artist"
    relationship: many_to_one
    sql_on: ${facts_prod_dim_release.artist_id} = ${facts_prod_dim_artist.artist_id} ;;
    fields: [
      artist_name, facts_prod_dim_artist.artist_id
    ]
  }

  # join: release_genre {
  #   from: orch_app_ar_genre
  #   view_label: "Release"
  #   relationship: many_to_one
  #   sql_on: ${orch_app_ar_releases.release_genre_id} = ${release_genre.genre_id} ;;
  # }

  join: facts_prod_dim_label {
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_black17_summary_streams.label_id} = ${facts_prod_dim_label.label_id} ;;
    fields: [
      label_name,
      number_of_labels
    ]
  }

  # join: label_country {
  #   from: orch_app_ar_country
  #   view_label: "Label"
  #   relationship: many_to_one
  #   sql_on: ${facts_prod_dim_label.country_id} = ${label_country.id} ;;
  #   fields: [name]
  # }

  # join: orch_app_ar_vendor {
  #   view_label: "Label"
  #   #sql_on: ${int_dbt_prod_agg_spotify_model.labelid} = ${orch_app_ar_vendor.vendor_id} ;;
  #   sql_on: ${facts_prod_dim_release.label_id} = ${orch_app_ar_vendor.vendor_id} ;;
  #   relationship: many_to_one
  #   fields: []
  # }

  # join: label_manager {
  #   from: orch_app_ar_orchadmin_users
  #   view_label: "Label"
  #   relationship: many_to_one
  #   sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  # }

  # join: quarterback_label_manager {
  #   from: orch_app_ar_orchadmin_users
  #   view_label: "Label"
  #   relationship: many_to_one
  #   sql_on: ${orch_app_ar_vendor.quarterback_label_manager} = ${quarterback_label_manager.id} ;;
  # }

  # join: int_dbt_prod_awal_tier_groups {
  #   view_label: "Orchard/AWAL Tiers"
  #   relationship: many_to_one
  #   sql_on: ${int_dbt_prod_black17_summary_streams.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_release_subgenre {
  #   relationship: one_to_one
  #   sql_on: ${orch_app_ar_releases.release_id} = ${orch_app_ar_release_subgenre.release_id} ;;
  #   fields: []
  # }

  # join: orch_app_ar_subgenre {
  #   view_label: "Release"
  #   relationship: many_to_one
  #   sql_on: ${orch_app_ar_release_subgenre.subgenre_id} = ${orch_app_ar_subgenre.subgenre_id} ;;
  # }

  # join: orch_app_ar_mkt_priority {
  #   view_label: "Marketing Information"
  #   relationship: one_to_many
  #   sql_on: ${orch_app_ar_releases.release_id} = ${orch_app_ar_mkt_priority.release_id} ;;
  # }

  # join: dt_flatten_marketing_info {
  #   view_label: "Marketing Information"
  #   relationship: one_to_one
  #   sql_on: ${orch_app_ar_releases.release_id} = ${dt_flatten_marketing_info.release_id} ;;
  # }

  # join: market_country {
  #   from: dt_flatten_country_region
  #   view_label: "Marketing Information"
  #   relationship: many_to_one
  #   sql_on: ${orch_app_ar_mkt_priority.country_id} = ${market_country.country_region_id} ;;
  # }

  # join: int_dbt_prod_product_manager_mapping_union {
  #   sql_on: ${facts_prod_dim_release.label_id} = ${int_dbt_prod_product_manager_mapping_union.label_id} and
  #     ${int_dbt_prod_black17_summary_streams.upc} = ${int_dbt_prod_product_manager_mapping_union.upc};;
  #   relationship: many_to_one
  #   view_label: "Product Manager"
  # }

#   join: int_prod_vw_deleted_releases {
#     view_label: "Release"
#     relationship: one_to_one
#     sql_on: ${orch_app_ar_releases.upc} = ${int_prod_vw_deleted_releases.upc} ;;
#     fields: [date_deleted]
#   }

}