view: orch_app_ar_language {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.language ;;

  dimension: apple_compatible {
    type: number
    sql: ${TABLE}.apple_compatible ;;
  }

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

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

  dimension: language {
    type: string
    label: "Audio Language"
    sql: ${TABLE}.language ;;
  }

  dimension: language_is_English {
    type: string
    label: "Track Audio Language is English (Y/N)"
    sql: iff(upper(${TABLE}.language) = upper('English'),'Yes','No') ;;
  }

  dimension: language_is_instrumental {
    type: string
    label: "Track is Instrumental (Y/N)"
    sql: iff(upper(${TABLE}.language) = upper('Instrumental'),'Yes','No') ;;
  }

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