view: vendor_dms_restriction_snowflake {
  derived_table: {
    sql: SELECT
          id,
          TRY_TO_NUMBER(a.value::string) AS dms_id,
          CONCAT(id, dms_id) AS primary_key
      FROM royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract,
          LATERAL FLATTEN(INPUT => SPLIT(dms_carve_out, ',')) a
      WHERE primary_key IS NOT NULL
       ;;
  }

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

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

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

  measure: count {
    label: "Count Restrictions"
    type: number
    sql: COUNT(DISTINCT ${TABLE}.primary_key) ;;
  }

#   measure: concat_count {
#     label: "Count Restrictions (Labeled)"
#     type: string
#     sql: IFF(COUNT(DISTINCT ${TABLE}.primary_key) = 1,
#       '1 Store/Territory Restriction', CONCAT(COUNT(DISTINCT ${TABLE}.primary_key), ' Store/Territory Restrictions')) ;;
#     html: {% if value == '0 Store/Territory Restrictions' %}
#       <p style="color: black; background-color: #99e699; font-size:100%;">{{ rendered_value }}</p>
#       {% else %} <p style="color: black; background-color: #ff8680; font-size:100%;">{{ rendered_value }}</p>
#     {% endif %} ;;
#   }

  measure: list_restrictions {
    type: string
    sql: LISTAGG(DISTINCT (${vdr_store.customer_name}||' '||${vdr_country.country_code}), ', ') ;;
  }

  set: detail {
    fields: [id, dms_id]
  }

}