view: int_dbt_prod_knr_statement_emails {
  sql_table_name: intelligence.dbt_prod_knr.knr_account_payment_email_list ;;

  dimension: client_manager {
    description: "Client manager's name"
    type: string
    sql: ${TABLE}.client_manager ;;
  }

  dimension: statement_schedule {
    description: "Statement Schedule (monthly/quarterly)"
    type: string
    sql: ${TABLE}.statement_schedule ;;
  }

  dimension: recipient_email_address {
    description: "Semi colon separated list of client recipient email addresses"
    type: string
    sql: ${TABLE}.recipient_email_address ;;
  }

  dimension: recipient_name {
    description: "Semi colon separated list of client recipient names"
    type: string
    sql: ${TABLE}.recipient_name ;;
  }

  dimension: label_id {
    description: "Semi colon separated list of client's label id's"
    type: string
    sql: ${TABLE}.label_id ;;
  }

  dimension: client_name {
    description: "Semi colon separated list of client or label names"
    type: string
    sql: ${TABLE}.client_name ;;
  }

}