# View: vendor_dms_master_restriction

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

## Overview

- **File Size:** 1275 bytes
- **Lines of Code:** 48
- **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: SELECT vendor_contract_id, distribution_type_id,
        GROUP_CONCAT(
        (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) SEPARATOR ", ") as carved_from_amazon_itunes_spotify_youtube
      FROM art_relations.vendor_dms_master_restriction
      GROUP BY 1,2
       ;;
```