view: dt_apple_id_mapping_sony_and_orchard {
  sql_table_name: intelligence.dbt_prod.base_apple_id_mapping ;;
 # derived_table: {
#    sql: SELECT
#            apple_id,
#            TRY_TO_NUMBER(orchard_release_id) AS upc,
#            orchard_track_id AS isrc,
#            album_or_track,
#            'Orchard' as distributor
#        FROM facts.prod.apple_id_mapping
#        UNION ALL
#        SELECT
#            apple_id,
#            TRY_TO_NUMBER(upc) AS upc,
#            isrc,
#            album_or_track,
#            'Sony' as distributor
#        FROM facts.prod.sony_apple_id_mapping;;
#  }


  dimension: apple_id {
    type: string
    label: "Apple Id"
    sql: ${TABLE}.apple_id ;;
  }

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

  dimension: isrc {
    type: string
    sql: ${TABLE}.isrc ;;
    hidden: yes
  }

  dimension: album_or_track {
    type: string
    sql: ${TABLE}.album_or_track ;;
    hidden: yes
  }

  dimension: distributor {
    type: string
    sql: ${TABLE}.distributor ;;
    hidden: yes
  }

}