view: dt_store_artist_id_name {
  derived_table: {
    sql: SELECT
    lp.name AS release_artist,
    lp.uuid,
    'Apple' AS store_name,
    lp.apple_music_id AS store_artist_id
    FROM
    facts.prod.label_participant lp

    UNION ALL

    SELECT
    lp.name AS release_artist,
    lp.uuid,
    'Spotify' AS store_name,
    lp.spotify_id AS store_artist_id
    FROM
    facts.prod.label_participant lp;;
  }


# Add fields for the derived table

  dimension: release_artist {
    sql: ${TABLE}.release_artist ;;
    hidden: yes
  }

  dimension: uuid {
    sql: ${TABLE}.uuid ;;
    hidden: yes
  }

  dimension: store_name {
    sql: ${TABLE}.store_name ;;
    group_label: "Release Artist Participation"
    description: "Store name for Release Artist"
    }

  dimension: store_artist_id {
    sql: ${TABLE}.store_artist_id ;;
    group_label: "Release Artist Participation"
    description: "Store Artist ID"
  }
}