connection: "accounting_aggregates"

label: "Som Livre"

# include all the views
include: "*.view"

# include all the dashboards
include: "*.dashboard"

explore: spotify_sos_aggregated {
  label: "Spotify"
  sql_always_where: ${aggregate} = 'Track Level' ;;

  join: bi_country_view {
    sql_on: spotify_sos_aggregated.country_code=bi_country_view.country_code ;;
    relationship: many_to_one
  }

  join: spot_metadata_playlist_metadata {
    view_label: "PPlaylist"
    foreign_key: playlist_id
    relationship: many_to_one
  }

  join: bi_track_view {
    view_label: "production_dim_track"
    sql_on: ${spotify_sos_aggregated.isrc} = ${bi_track_view.isrc} and ${spotify_sos_aggregated.album_code} = ${bi_track_view.upc} ;;
    relationship: many_to_one
  }

  join: bi_release_with_metadata_view {
    view_label: "bi_release_with_metadata_view"
    sql_on: ${spotify_sos_aggregated.album_code} = ${bi_release_with_metadata_view.upc} ;;
    relationship: many_to_one
  }
}