connection: "snowflake_via_lookerappadmin"

include: "*.view.lkml"                       # include all views in this project




explore: dt_trending_tracks {
  hidden: yes
  view_label: "Trending Tracks"
  join: facts_prod_dim_canonical_track_metadata {
    sql_on: ${facts_prod_dim_canonical_track_metadata.isrc} = ${dt_trending_tracks.isrc}
            AND ${facts_prod_dim_canonical_track_metadata.labelid} = ${dt_trending_tracks.labelid}
            AND zeroifnull(${facts_prod_dim_canonical_track_metadata.subaccountid}) = ${dt_trending_tracks.subaccountid};;
    relationship: one_to_one
    fields: []
  }

  join: orch_app_ar_track {
    sql_on: ${facts_prod_dim_canonical_track_metadata.track_unique_id}=${orch_app_ar_track.tuid} ;;
    relationship: one_to_one
    view_label: "Track"
  }

  join: orch_app_ar_releases {
    sql_on: ${orch_app_ar_releases.upc}=${facts_prod_dim_canonical_track_metadata.upc} ;;
    relationship: one_to_many
    view_label: "Release"
  }

  join: orch_app_ar_genre {
    view_label: "Release"
    sql_on: ${orch_app_ar_genre.genre_id}=${orch_app_ar_releases.release_genre_id} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_vendor {
    sql_on: ${facts_prod_dim_canonical_track_metadata.labelid}=${orch_app_ar_vendor.vendor_id} ;;
    relationship: many_to_one
    view_label: "Label"
  }



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: orch_app_ar_subaccount {
    sql_on: ${orch_app_ar_subaccount.subaccount_id}=${facts_prod_dim_canonical_track_metadata.subaccountid};;
    relationship: one_to_many
    view_label: "Subaccount"
  }

  join: orch_app_ar_artist_info {
    sql_on: ${orch_app_ar_artist_info.artist_id}=${orch_app_ar_releases.artist_id} ;;
    relationship: one_to_many
    view_label: "Artist"
  }

}