view: orch_app_ar_product_split {
  sql_table_name: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_SPLIT ;;

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

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

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

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

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

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

  dimension: _fivetran_synced {
    type:date_time
    sql: ${TABLE}._fivetran_synced ;;
    hidden: yes
  }


  dimension: product_split_rate {
    label: "Product Split Rate"
    type: number
    sql: ROUND(1-${TABLE}.product_split_rate,2) ;;
    value_format: "0%"
  }

}