view: int_dbt_prod_dt_mechanical_clients {
  sql_table_name:  INTELLIGENCE.DBT_PROD.DT_MECHANICAL_CLIENTS ;;
#   derived_table: {
#     sql: select vc.vendor_id, oms_type, cont_start
# from royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract vc
# inner join intelligence.dbt_prod.active_vendor_contracts avc on avc.vendor_contract_id = vc.id
# group by 1,2,3 ;;
#   }

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

  dimension: mechanical_client {
    label: "Is Mechanical Client"
    type: yesno
    sql: IFF(${TABLE}.oms_type in ('orchard', 'label', 'both')
      , TRUE, FALSE) ;;
  }


}