connection: "snowflake_via_lookerappadmin"
label: "Project Moments"

include: "dev_eng_eimpara_FOURIERTABLE_JUL_SEPT_22.view.lkml"
include: "dev_eng_eimpara_FOURIERTABLE_APR_SEPT_22.view.lkml"
include: "dev_eng_eimpara_FOURIERTABLE_FEB_SEPT_22.view.lkml"
include: "facts_prod_dim_track.view.lkml"
include: "facts_prod_dim_release.view.lkml"
include: "facts_prod_dim_artist.view.lkml"
include: "facts_prod_dim_label.view.lkml"
include: "orch_app_ar_artist_info.view.lkml"
include: "dt_project_moments_cluster_groups_140_days.view.lkml"
include: "dt_project_moments_pred_vs_actual_140_days.view.lkml"
include: "dt_project_moments_cluster_group_audio_upper_x_lower_bounds.view.lkml"
include: "dt_project_moments_cluster_groups_v2_fuzzy_logic.view.lkml"
include: "dt_project_moments_cluster_group_audio_upper_x_lower_bounds_v2_fuzzy_logic.view.lkml"
include: "dt_project_moments_som_cluster_groups.view.lkml"
include: "dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic.view.lkml"
include: "dt_project_moments_fuzzy_cluster_v4.view.lkml"
include: "dt_project_moments_cluster_group_upper_x_lower_bounds_fuzzy_v4.view.lkml"
include: "int_dev_tallman_moments_performance_groups_v1.view.lkml"
include: "/views/moments_140_days_k_proto_v3_copy.view.lkml"
include: "/views/moments_track_name_isrc_list.view.lkml"
include: "facts_prod_dim_genre.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "int_dbt_prod_project_moments_track_groupings_info.view.lkml"
include: "int_dbt_prod_moments_watchlist.view.lkml"
include: "/views/project_moments_ma_calculation.view.lkml"
include: "/views/project_moments_hedra_output_table.view.lkml"
include: "/views/project_moments_hedra_output_140_days_table.view.lkml"
include: "/views/uniti_recommends_refined.view.lkml"
include: "/views/dt_project_moments_uniti_graphical_representation.view.lkml"


explore: dev_eng_eimpara_fouriertable_jul_sept_22 {
  hidden: yes
  case_sensitive: no
  label: "Moments Fourier Table - 70 Days - July to Sept 8th"

  join: facts_prod_dim_track {
    view_label: "Track"
    sql_on: ${dev_eng_eimpara_fouriertable_jul_sept_22.ISRC} = ${facts_prod_dim_track.isrc} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_track.track_name]
  }

  join: facts_prod_dim_release {
    view_label: "Release"
    sql_on: ${facts_prod_dim_track.upc} = ${facts_prod_dim_release.upc} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_release.release_name]
  }

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

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


explore: dev_eng_eimpara_fouriertable_apr_sept_22 {
  hidden: yes
  case_sensitive: no
  label: "Moments Fourier Table - 140 Days - April to Sept 8th"

  join: facts_prod_dim_track {
    view_label: "Track"
    sql_on: ${dev_eng_eimpara_fouriertable_apr_sept_22.ISRC} = ${facts_prod_dim_track.isrc} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_track.track_name]
  }

  join: facts_prod_dim_release {
    view_label: "Release"
    sql_on: ${facts_prod_dim_track.upc} = ${facts_prod_dim_release.upc} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_release.release_name]
  }

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

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

explore: dev_eng_eimpara_fouriertable_feb_sept_22 {
  hidden: yes
  case_sensitive: no
  label: "Moments Fourier Table - 210 Days - Feb to Sept 8th"

  join: facts_prod_dim_track {
    view_label: "Track"
    sql_on: ${dev_eng_eimpara_fouriertable_feb_sept_22.ISRC} = ${facts_prod_dim_track.isrc} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_track.track_name]
  }

  join: facts_prod_dim_release {
    view_label: "Release"
    sql_on: ${facts_prod_dim_track.upc} = ${facts_prod_dim_release.upc} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_release.release_name]
  }

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

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




explore: dt_project_moments_cluster_groups_140_days {
  view_label: "Moments - Cluster Groups"
  hidden: yes
  case_sensitive: no
}

explore: dt_project_moments_pred_vs_actual_140_days {
  view_label: "Moments - Actual vs Predicted"
  hidden: yes
  case_sensitive: no
}


explore: dt_project_moments_cluster_group_audio_upper_x_lower_bounds {
  view_label: "Moments - Cluster Groups Audio Profiles"
  hidden: yes
  case_sensitive: no
}



explore:dt_project_moments_cluster_groups_v2_fuzzy_logic  {
  view_label: "Moments - Cluster Groups - Version 2"
  hidden: yes
  case_sensitive: no
}

explore: dt_project_moments_cluster_group_audio_upper_x_lower_bounds_v2_fuzzy_logic {
  view_label: "Moments - Cluster Groups Audio Profiles - Version 2"
  hidden: yes
  case_sensitive: no

}

explore: dt_project_moments_som_cluster_groups {
  view_label: "Moments - Cluster Groups - SOM Clusters"
  hidden: yes
  case_sensitive: no
}

explore: dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic {
  view_label: "Moments - Cluster Groups Audio Profiles - SOM Clusters"
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_moments_watchlist {
  view_label: "Moments Watchlist Info"
  hidden: yes
  case_sensitive: no
}

explore: dt_project_moments_fuzzy_cluster_v4 {
  view_label: "Moments - Cluster Groups - Version 4"
  hidden: yes
  case_sensitive: no
}

explore: dt_project_moments_cluster_group_upper_x_lower_bounds_fuzzy_v4 {
  view_label: "Moments - Cluster Groups Audio Profiles - Version 4"
  hidden: yes
  case_sensitive: no
}


explore: int_dev_tallman_moments_performance_groups_v1 {
  view_label: "Moments - Performance Groups - Version 1"
  hidden: yes
  case_sensitive: no

#  join: moments_140_days_k_proto_v3_copy {
#    view_label: "K Proto Copy"
#    sql_on: ${int_dev_tallman_moments_performance_groups_v1.isrc} = ${moments_140_days_k_proto_v3_copy.isrc} ;;
#  }

#  join: facts_prod_dim_track {
#    view_label: "Track"
#    sql_on: ${moments_140_days_k_proto_v3_copy.isrc} = ${facts_prod_dim_track.isrc} ;;
#    relationship: one_to_many
#    fields: [facts_prod_dim_track.track_name]
#  }

#  join: facts_prod_dim_release {
#    view_label: "Release"
#    sql_on: ${moments_140_days_k_proto_v3_copy.upc} = ${facts_prod_dim_release.upc} ;;
#    relationship: one_to_many
#    fields: [facts_prod_dim_release.release_name]
#  }

  join: facts_prod_dim_artist {
    view_label: "Artist"
    sql_on: ${facts_prod_dim_artist.artist_id} = ${int_dev_tallman_moments_performance_groups_v1.artistid}  ;;
    fields: [facts_prod_dim_artist.artist_name]
  }

  join: facts_prod_dim_label {
    view_label: "Label"
    sql_on: ${facts_prod_dim_label.label_id} = ${int_dev_tallman_moments_performance_groups_v1.labelid} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_label.label_name, facts_prod_dim_label.label_id]
  }

  join: facts_prod_dim_genre {
    view_label: "Genre"
    sql_on: ${facts_prod_dim_genre.genre_id} = ${int_dev_tallman_moments_performance_groups_v1.genreid} ;;
    relationship: one_to_many
    fields: [facts_prod_dim_genre.genre]
  }

#  join: moments_track_name_isrc_list {
 #   view_label: "Track"
#   sql_on: ${int_dev_tallman_moments_performance_groups_v1.isrc} = ${moments_track_name_isrc_list.isrc} ;;
 #   relationship: one_to_one
 #   fields: [track_name, isrc]
 # }

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

  }



}




explore: project_moments_ma_calculation {
  view_label: "Project Moments Moving Average Calc"
  hidden: yes
  case_sensitive: no

  join: facts_prod_dim_artist {
    view_label: "Artist"
    sql_on: ${facts_prod_dim_artist.artist_id} = ${project_moments_ma_calculation.artistid}  ;;
    fields: [facts_prod_dim_artist.artist_name]
  }

}



explore: project_moments_hedra_output_table {
  view_label: "Project Moments Hedra"
  hidden: yes
  case_sensitive: no
}

explore: project_moments_hedra_output_140_days_table {
  view_label: "Project Moments Hedra"
  hidden: yes
  case_sensitive: no
}


explore: uniti_recommends_refined {
  view_label: "Uniti Recommends"
  hidden: yes
  case_sensitive: no
}

explore: dt_project_moments_uniti_graphical_representation {
  view_label: "Uniti Recommends Graph"
  hidden: yes
  case_sensitive: no
}