# View: restrictions_aggregated_release_store_snowflake

**View Name:** restrictions_aggregated_release_store_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Customer_Master_Master, Art_Relations_Prod_Art_Relations.Distribution_Type, Art_Relations_Prod_Art_Relations.Release_Dms_Master_Restriction, Art_Relations_Prod_Art_Relations.Releases + 3 more`
**File Path:** `restrictions_aggregated_release_store_snowflake.view.lkml`

## Overview

- **File Size:** 2625 bytes
- **Lines of Code:** 70
- **Dimensions:** 2
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `store_name` | string |

## Measures

| Name | Type |
|------|------|
| `count_aggregate_restrictions` | count_distinct |
| `list_aggregate_restrictions` | string |

## Filters

- `name`

## Derived Table

```sql
sql:
SELECT agg_restrictions.release_id, cmm.customer_name, dt.name
FROM (
    SELECT r.release_id, vdmr.customer_master_master_id, vdmr.distribution_type_id
    FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id
        INNER JOIN intelligence.dbt_prod.active_vendor_contracts vw ON ai.vendor_id = vw.vendor_id
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_dms_master_restriction vdmr ON vw.vendor_contract_id = vdmr.vendor_contract_id
    UNION ALL
        SELECT r.release_id, sdmr.customer_master_master_id, NULL AS distribution_type_id
        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
            INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.subaccount_dms_master_restriction sdmr ON r.subaccount_id = sdmr.subaccount_id
        WHERE r.subaccount_id IS NOT NULL
    UNION ALL
        SELECT release_id, customer_master_master_id, distribution_type_id
        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.release_dms_master_restriction
) agg_restrictions
    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master cmm ON cmm.customer_master_master_id = agg_restrictions.customer_master_master_id
    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_type dt ON dt.id = agg_restrictions.distribution_type_id
WHERE {% condition name %
```