# View: restrictions_aggregated_subaccount_substore_snowflake

**View Name:** restrictions_aggregated_subaccount_substore_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Customer_Master, Art_Relations_Prod_Art_Relations.Subaccount, Art_Relations_Prod_Art_Relations.Subaccount_Dms_Restriction, Dbt_Prod.Active_Vendor_Contracts, Intelligence.Dbt_Prod + 3 more`
**File Path:** `restrictions_aggregated_subaccount_substore_snowflake.view.lkml`

## Overview

- **File Size:** 1506 bytes
- **Lines of Code:** 45
- **Dimensions:** 2
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `subaccount_id` | number |
| `name` | string |

## Measures

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

## Derived Table

```sql
sql:
SELECT agg_restrictions.subaccount_id, cm.name
FROM (
    SELECT sa.subaccount_id, vdr.dms_id
    FROM orchard_app_reporting_v2.art_relations_prod_art_relations.subaccount sa
        INNER JOIN intelligence.dbt_prod.active_vendor_contracts vw ON sa.vendor_id = vw.vendor_id
        INNER JOIN (
            SELECT id, TRY_TO_NUMBER(a.value::string) AS dms_id
            FROM royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract,
            LATERAL FLATTEN(INPUT => SPLIT(dms_carve_out, ',')) a) vdr ON vdr.id = vw.vendor_contract_id
    WHERE vdr.dms_id IS NOT NULL
    UNION ALL
        SELECT subaccount_id, dms_id
        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.subaccount_dms_restriction
) agg_restrictions
    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master cm ON agg_restrictions.dms_id = cm.customer_id ;;
```