connection: "snowflake_via_lookerappadmin"

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




explore: dt_top_tracks {
  hidden: yes
  join: facts_prod_dim_label {
    view_label: "Label"
    sql_on: ${facts_prod_dim_label.label_id}=${dt_top_tracks.labelid} ;;
    relationship: one_to_many
  }

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

  join: facts_prod_dim_track {
    view_label: "Track"
    sql_on: ${facts_prod_dim_track.track_id}=${dt_top_tracks.trackid} ;;
    relationship:  one_to_many
  }

}

explore: dt_top_tracks_test {
  hidden: yes
  join: facts_prod_dim_label {
    view_label: "Label"
    sql_on: ${facts_prod_dim_label.label_id}=${dt_top_tracks_test.labelid} ;;
    relationship: one_to_many
  }

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

  join: facts_prod_dim_track {
    view_label: "Track"
    sql_on: ${facts_prod_dim_track.track_id}=${dt_top_tracks_test.trackid} ;;
    relationship:  one_to_many
  }

}