connection: "snowflake_via_lookerappadmin"
include: "*.view.lkml"

explore:  int_prod_daily_top_content {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_prod_daily_top_content.labelid} ;;
    relationship: one_to_many
  }

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

  join: facts_prod_dim_track {
    sql_on: ${facts_prod_dim_track.track_id}=${int_prod_daily_top_content.trackid} ;;
    relationship: one_to_many
    fields: []
  }

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

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.release_id}=${orch_app_ar_track.release_id} ;;
    relationship: one_to_many
  }

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