label: "Apple Music SOS"

connection: "accounting_aggregates"

week_start_day: friday

persist_for: "36 hours"

include: "*.view"

explore: streams_per_apple_id_by_all_attributes {
  extends: [_base_apple_music_aggregates]
  view_name: apple_music_sos_aggregated
  from: apple_music_sos_aggregated
  sql_always_where: ${aggregate}='Streams Per Apple ID By All Attributes' ;;
  label: "Track Level"
  hidden: yes
}

explore: release_level_streams_by_all_attributes {
  extends: [_base_apple_music_aggregates]
  view_name: apple_music_sos_aggregated
  from: apple_music_sos_aggregated
  sql_always_where: ${aggregate}='Release Level Streams By All Attributes' ;;
  label: "Release Level"
  hidden: yes
}

explore: label_level_streams_by_all_attributes {
  extends: [_base_apple_music_aggregates]
  view_name: apple_music_sos_aggregated
  from: apple_music_sos_aggregated
  sql_always_where: ${aggregate}='Label Level Streams By All Attributes' ;;
  label: "Label Level"
  hidden: yes
}