connection: "snowflake_via_lookerappadmin"

include: "int_dbt_prod_rsd_v2.view.lkml"
include: "orch_app_ar_artist_info.view.lkml"
include: "cm_orchard_join.view.lkml"
include: "cm_raw_data_spotify_artist.view.lkml"
include: "int_dbt_prod_cm_spotify_artist_stat_clean.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "dt_agg_restrictions_release_territory.view.lkml"
include: "dt_agg_restrictions_release_store.view.lkml"
include: "orch_app_ar_orchadmin_users.view.lkml"
include: "dbt_prod_pitch_info_extraction.view.lkml"
include: "int_dbt_prod_stg_cm_social_followers_clean.view.lkml"
include: "orch_app_ar_focus_track.view.lkml"
include: "orch_app_ar_track.view.lkml"
include: "dt_bits_per_sample.view.lkml"
include: "int_dbt_prod_chartmetric_social_stats.view.lkml"
include: "orch_app_ar_track_instant_grat.view.lkml"
include: "int_prod_rcl_track_ig_changes.view.lkml"


explore: int_dbt_prod_rsd_v2 {
  hidden: yes
  case_sensitive: no


  join: orch_app_ar_artist_info {
    view_label: "Artist"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_rsd_v2.artist_id} = ${orch_app_ar_artist_info.artist_id} ;;
    fields: []
  }

  join: cm_orchard_join {
    view_label: "Artist"
    relationship: many_to_one
    sql_on: ${orch_app_ar_artist_info.artist_id} = ${cm_orchard_join.artistid} ;;
    fields: []
  }

  join: cm_raw_data_spotify_artist {
    view_label: "Artist"
    relationship: one_to_many
    sql_on: ${cm_orchard_join.chartmetricid} = ${cm_raw_data_spotify_artist.cm_artist} ;;
    fields: []
  }

  join: int_dbt_prod_cm_spotify_artist_stat_clean {
    view_label: "Spotify Stats"
    relationship: one_to_one
    sql_on: ${cm_raw_data_spotify_artist.id} =  ${int_dbt_prod_cm_spotify_artist_stat_clean.spotify_artist} ;;
    fields: [spotify_followers,spotify_popularity,spotify_monthly_listeners]
  }

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

  join: dt_agg_restrictions_release_territory {
    view_label: "Release Restrictions (Territory)"
    relationship: one_to_one
    sql_on: ${dt_agg_restrictions_release_territory.release_id} = ${int_dbt_prod_rsd_v2.release_id} ;;
  }

  join: dt_agg_restrictions_release_store {
    view_label: "Release Restrictions (Store)"
    relationship: one_to_one
    sql_on: ${dt_agg_restrictions_release_store.release_id} = ${int_dbt_prod_rsd_v2.release_id} ;;
  }

  join: quarterback_label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Release Schedule Dashboard"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_rsd_v2.quarterback_label_manager} = ${quarterback_label_manager.id} ;;
  }

  join: dbt_prod_pitch_info_extraction {
    sql_on: ${dbt_prod_pitch_info_extraction.upc} = ${int_dbt_prod_rsd_v2.upc};;
    relationship: one_to_one
    view_label: "Pitch Info"
  }

 join: orch_app_ar_focus_track {
    sql_on: ${int_dbt_prod_rsd_v2.release_id} = ${orch_app_ar_focus_track.release_id} ;;
    relationship: one_to_many
    view_label: "Focus Track"
  }

join: orch_app_ar_track {
    sql_on: ${orch_app_ar_track.release_id} = ${int_dbt_prod_rsd_v2.release_id};;
    fields: [isrc]
  }

  join: dt_bits_per_sample {
    relationship:  one_to_one
    sql_on: ${int_dbt_prod_rsd_v2.upc} = ${dt_bits_per_sample.upc} ;;
  }

  join:int_dbt_prod_chartmetric_social_stats{
    sql_on: ${int_dbt_prod_chartmetric_social_stats.artist_id} = ${int_dbt_prod_rsd_v2.artist_id};;
    relationship: many_to_one
    view_label: "Chartmetric Social Stats"
  }

  join: orch_app_ar_track_instant_grat {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.tuid}=${orch_app_ar_track_instant_grat.tuid} ;;
  }

  join: int_prod_rcl_track_ig_changes {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.tuid}=${int_prod_rcl_track_ig_changes.trackid};;
    fields: [int_prod_rcl_track_ig_changes.instant_grat_date]
  }
}