view: int_prod_internal_conflicts {
  sql_table_name: INTELLIGENCE.DBT_PROD.INTERNAL_CONFLICTS ;;
# derived_table: {
#    sql: SELECT * FROM intelligence.prod.internal_conflicts
#      ;;
#  }

  dimension: label_id {
    type: string
    sql: ${TABLE}."LABELID" ;;
  }

  dimension: label_name {
    type: string
    sql: ${TABLE}."LABELNAME" ;;
  }

  dimension: subaccount_id {
    type: string
    sql: ${TABLE}.subaccountid ;;
  }

  dimension: subaccount_name {
    type: string
    sql: ${TABLE}.subaccountname ;;
  }

  dimension: upc {
    type: string
    sql: ${TABLE}."UPC" ;;
  }

  dimension: release_name {
    type: string
    sql: ${TABLE}."RELEASENAME" ;;
  }

  dimension: track_name {
    type: string
    sql: ${TABLE}."TRACKNAME" ;;
  }

  dimension: artist_name {
    type: string
    sql: ${TABLE}."ARTISTNAME" ;;
  }

  dimension: isrc {
    type: string
    sql: ${TABLE}."ISRC" ;;
  }

  dimension: tuid {
    type: string
    sql: ${TABLE}."TUID" ;;
  }

  dimension: matched_label_id {
    type: string
    sql: ${TABLE}."MATCHED_LABELID" ;;
  }

  dimension: matched_label_name {
    type: string
    sql: ${TABLE}."MATCHED_LABELNAME" ;;
  }

  dimension: matched_subaccount_id {
    type: string
    sql: ${TABLE}.matched_subaccountid ;;
  }

  dimension: matched_subaccount_name {
    type: string
    sql: ${TABLE}.matched_subaccountname ;;
  }

  dimension: matched_upc {
    type: string
    sql: ${TABLE}."MATCHED_UPC" ;;
  }

  dimension: matched_release_name {
    type: string
    sql: ${TABLE}."MATCHED_RELEASE_NAME" ;;
  }

  dimension: matched_track_name {
    type: string
    sql: ${TABLE}."MATCHED_TRACKNAME" ;;
  }

  dimension: matched_artist_name {
    type: string
    sql: ${TABLE}."MATCHED_ARTISTNAME" ;;
  }

  dimension: matched_isrc {
    type: string
    sql: ${TABLE}."MATCHED_ISRC" ;;
  }

  dimension: matched_tuid {
    type: string
    sql: ${TABLE}."MATCHED_TUID" ;;
  }

  dimension: conflicting_territories {
    type: string
    sql: ${TABLE}."CONFLICTING_TERRITORIES" ;;
    html:
    {% assign countries = value | split: ";" %}
    {% unless countries.size == 0 %}

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

    <ul>
    {% for country in countries %}
    <li>{{country}}</li>
    {% endfor %}
    </ul>
    </details>

    {% endunless %}
   ;;
  }

  measure: list_conflicting_territories {
    type: string
    sql: listagg(${TABLE}."CONFLICTING_TERRITORIES",',') ;;
  }
}