view: vendor_territory_restriction_snowflake_1 {
  derived_table: {
    sql: SELECT
        id,
        TRY_TO_NUMBER(a.value::string) AS country_id,
        CONCAT(id, country_id) AS primary_key
      FROM royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract,
        LATERAL FLATTEN(INPUT => SPLIT(territory_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: country_id {
    hidden: yes
    type: number
    sql: ${TABLE}.COUNTRY_ID ;;
  }

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

#   measure: count_restrictions {
#     label: "Count Restrictions (Labeled)"
#     type: string
#     sql: IFF(COUNT(DISTINCT primary_key) = 1,
#       '1 Territory Restriction', CONCAT(COUNT(DISTINCT primary_key), ' Territory Restrictions')) ;;
#     html: {% if value == '0 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 ${vtr_country.name}, ', ') WITHIN GROUP (ORDER BY ${vtr_country.name} ASC) ;;
  }

  set: detail {
    fields: [
      primary_key,
      id,
      country_id
    ]
  }
}