view: orch_app_ar_youtube_channel {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.youtube_channel ;;

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

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

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

  dimension: monetization_status {
    type: string
    hidden: yes
    label: "Channel Monetization Status"
    sql: ${TABLE}.monetization_status ;;
  }

  dimension: is_orchard_channel {
    hidden: yes
    label: "Channel in MCN?"
    type: string
    sql: CASE
    WHEN ${TABLE}.youtube_channel_id is not null THEN 'Yes'
    ELSE 'No'
    END ;;
  }

}