view: dt_release_country_of_origin_custom {
  derived_table: {
    sql: select upc, country_of_origin, c.country_code
      from ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASES r
      inner join ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.COUNTRY c on r.country_of_origin = c.id
      where country_of_origin != 0
      and distribution_format_id NOT IN (1,57) ;;
  }

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

  dimension: country_code {
    type: string
    label: "Country of Origin"
    view_label: "Releases"
    sql: case when ${TABLE}.country_code = 'CS'
          then 'RS'
          else ${TABLE}.country_code
          end;;
  }

}