view: music_video_bundle_snowflake {
  derived_table: {
    sql: select r.release_id
        , case when type_count=2
               THEN 'bundle'
               ELSE t.track_type
               END AS music_video_bundle
from orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
left join orchard_app_reporting_v2.art_relations_prod_art_relations.track t on t.release_id=r.release_id
left join (
    select r.release_id
            ,count(distinct t.track_type) as type_count
    from orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
    left join orchard_app_reporting_v2.art_relations_prod_art_relations.track t on t.release_id=r.release_id
    group by 1
        ) track_type_count on track_type_count.release_id=r.release_id
where music_video_bundle is not null
group by 1, 2
 ;;
  }

  measure: count {
    type: count
    hidden: yes
    drill_fields: [detail*]
  }

  dimension: release_id {
    type: number
    hidden: yes
    sql: ${TABLE}.RELEASE_ID ;;
  }

  dimension: music_video_bundle {
    type: string
    label:  "Music or Video or Bundle?"
    hidden: no
    description: "This field shows if all content on a Release is Music, Video, or Both (Bundle)"
    sql: ${TABLE}.MUSIC_VIDEO_BUNDLE ;;
  }

  set: detail {
    fields: [release_id, music_video_bundle]
  }
}