view: orch_app_dd_customer_master_master {
  derived_table: {
    sql:
      SELECT
        b.*,
        a.status
    FROM orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master a
    INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.customer_master_master b ON a.customer_master_master_id=b.customer_master_master_id;;
  }
  dimension: customer_id {
    type: number
    primary_key:  yes
    sql: ${TABLE}.customer_master_master_id ;;
  }

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

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

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

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

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

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

}