view: dim_youtube_channel_names {
  sql_table_name: facts.prod.dim_youtube_channel_names ;;

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

  dimension: channel_name {
    type: string
    view_label: "YouTube Channel"
    label: "Channel Name"
    sql: ${TABLE}.channel_display_name;;
  }

  dimension: is_in_mcn {
    type: string
    view_label: "YouTube Channel"
    case_sensitive: no
    label: "Is in MCN (True/False)"
    sql:
      case
        when ${TABLE}.is_in_mcn = 'TRUE' then 'True'
        when ${TABLE}.is_in_mcn = 'FALSE' then 'False'
      else null
      end;;
  }

  dimension: channel_owner {
    type: string
    view_label: "YouTube Channel"
    case_sensitive: no
    label: "Channel Owner"
    description: "Channel Owner: UGC, MCN, VEVO"
    sql:case
          when ${TABLE}.channel_owner is null then 'UGC'
          else ${TABLE}.channel_owner
          end;;
  }

}