# View: dt_registry

**View Name:** dt_registry
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_REGISTRY`
**File Path:** `dt_registry.view.lkml`

## Overview

- **File Size:** 993 bytes
- **Lines of Code:** 48
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: with territories as (select isrc, tuid, internal_conflict,
- listagg(distinct(territory), ', ')

## Dimensions

| Name | Type |
|------|------|
| `tuid` | number |
| `isrc` | string |
| `territories` | string |

## Derived Table

```sql
#     sql: with territories as (select isrc, tuid, internal_conflict,
# listagg(distinct(territory), ', ')
# within group (order by territory)
# over (partition by tuid) as territories
# from FACTS.PROD.REGISTRY)

# select distinct(tuid),isrc, territories
# from territories ;;
#
```