view: track_artist_snowflake {
  derived_table: {
    sql:
      SELECT ta.track_id, ta.type, listagg(distinct ta.name, ', ')  as name
      from prod.dim_track_artist ta
      group by 1,2;;
}

#   dimension: id {
#     type: number
#     sql: ${TABLE}.ID ;;
#   }

  dimension: track_id {
    type: number
    sql: ${TABLE}.TRACK_ID ;;
  }

  dimension: type {
    type: string
    sql: ${TABLE}.type ;;
  }

  dimension: track_artist_name_featuring {
    label: "Track Artist (Featuring)"
    type: string
    sql: ${TABLE}.name;;
  }

  dimension: track_artist_name_performer {
    label: "Track Artist (Performer)"
    type: string
    sql: ${TABLE}.name;;
  }


  dimension: track_artist_name_remixer {
    label: "Track Artist (Remixer)"
    type: string
    sql: ${TABLE}.name;;
  }


  dimension: track_artist_name_composer {
    label: "Track Artist (Composer)"
    type: string
    sql: ${TABLE}.name ;;
  }


  dimension: track_artist_name_orchestra {
    label: "Track Artist (Orchestra)"
    type: string
    sql: ${TABLE}.name;;
  }

  dimension: track_artist_name_ensemble {
    label: "Track Artist (Ensemble)"
    type: string
    sql: ${TABLE}.name;;
  }

  dimension: track_artist_name_conductor {
    label: "Track Artist (Conductor)"
    type: string
    sql: ${TABLE}.name;;
  }

  dimension: track_artist_name_other {
    label: "Track Artist (Other)"
    description: "Track Artists that are not Composers, Conductors, Ensembles, Featuring, Orchestra, Performer, or Remixer"
    type: string
    sql: ${TABLE}.name;;
  }



  set: detail {
    fields: [
      track_id
      , type
      , track_artist_name_featuring
      , track_artist_name_composer
      , track_artist_name_conductor
      , track_artist_name_ensemble
      , track_artist_name_orchestra
      , track_artist_name_performer
      , track_artist_name_remixer
      , track_artist_name_other
      ]
  }
}