connection: "snowflake_via_lookerappadmin"

include: "*.view.lkml"                       # include all views in this project
# include: "my_dashboard.dashboard.lookml"   # include a LookML dashboard called my_dashboard



 explore: int_prod_analytics_report_full  {
  label: "Daily Top Spotify/Apple Music Tracks"
  view_label: "Metrics"
  hidden: yes

  join: facts_prod_dim_label {
      view_label: "Label"
      sql_on: ${facts_prod_dim_label.label_id}=${int_prod_analytics_report_full.labelid} ;;
      relationship: one_to_many
  }

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

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

  join: int_prod_date_definitions {
    view_label: "Date Definitions"
    type: cross
    relationship: many_to_one
  }

  }