# View: dt_vendor_dms_master_restriction

**View Name:** vendor_dms_master_restriction
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Vendor_Dms_Master_Restriction, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `dt_vendor_dms_master_restriction.view.lkml`

## Overview

- **File Size:** 1615 bytes
- **Lines of Code:** 56
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `restriction_id` | number |
| `customer_master_master_id` | number |
| `carved_from_amazon_itunes_spotify_youtube` | string |
| `distribution_type_id` | number |
| `vendor_contract_id` | number |

## Derived Table

```sql
sql: with setup as (

SELECT vendor_contract_id, distribution_type_id,
        (CASE
        when customer_master_master_id in (453,569) THEN 'YouTube'
        when customer_master_master_id = 1 THEN 'iTunes'
        when customer_master_master_id = 187 THEN 'Amazon'
        when customer_master_master_id = 286 THEN 'Spotify'
        END) as carved_from_amazon_itunes_spotify_youtube
      FROM ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.VENDOR_DMS_MASTER_RESTRICTION
      GROUP BY 1,2,3)

select vendor_contract_id, distribution_type_id,
listagg(distinct(carved_from_amazon_itunes_spotify_youtube), ', ')
WITHIN GROUP (order by carved_from_amazon_itunes_spotify_youtube)
    OVER (PARTITION BY vendor_contract_id) as carved_from_amazon_itunes_spotify_youtube
from setup
       ;;
```