view: dt_registry {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_REGISTRY ;;

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

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

  dimension: territories {
    label: "Registry Territories"
    type: string
    sql:  ${TABLE}.territories;;
    html:
    {% assign territories = value | split: ";" %}
    {% unless territories.size == 0 %}

      <details>
      <summary>Detail ({{territories.size}})</summary>

      <ul>
      {% for territory in territories %}
      <li>{{territory}}</li>
      {% endfor %}
      </ul>
      </details>

      {% endunless %}
      ;;
  }
}