connection: "snowflake_via_lookerappadmin"

include: "dt_playlisting_by_track.view.lkml"                # include all views in the views/ folder in this project
include: "facts_prod_dim_isrc.view.lkml"
include: "orch_app_ar_vendor.view.lkml"
include: "orch_app_ar_artist_info.view.lkml"
include: "facts_prod_dim_track.view.lkml"

 explore: dt_playlisting_by_track {

  join: facts_prod_dim_isrc {
    view_label: "Label"
    sql_on: ${dt_playlisting_by_track.isrc} = ${facts_prod_dim_isrc.isrc};;
    relationship: one_to_one
    fields: []
  }

  join: orch_app_ar_vendor {
    view_label: "Label"
    sql_on: ${facts_prod_dim_isrc.labelid} = ${orch_app_ar_vendor.vendor_id};;
    relationship: many_to_one
    fields: [orch_app_ar_vendor.vendor_id,orch_app_ar_vendor.label_name]
  }

  join: orch_app_ar_artist_info {
    view_label: "Artist"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${orch_app_ar_artist_info.vendor_id};;
    relationship: many_to_one
    fields: [orch_app_ar_artist_info.artist_id,orch_app_ar_artist_info.name]
  }

  join: facts_prod_dim_track {
    view_label: "Track"
    sql_on: ${facts_prod_dim_track.isrc} = ${dt_playlisting_by_track.isrc};;
    relationship: many_to_one
    fields: [facts_prod_dim_track.track_name]
  }


   }