# View: dt_agg_restrictions_subacct_store

**View Name:** dt_agg_restrictions_subacct_store
**Table Source:** `INTELLIGENCE.DBT_PROD.RESTRICTIONS_SUBACCOUNT_STORE`
**File Path:** `dt_agg_restrictions_subacct_store.view.lkml`

## Overview

- **File Size:** 2008 bytes
- **Lines of Code:** 50
- **Dimensions:** 3
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 1

## Comments & Notes

- derived_table: {
- SELECT agg_restrictions.subaccount_id, cmm.customer_name, dt.name
- SELECT sa.subaccount_id, vdmr.customer_master_master_id, vdmr.distribution_type_id

## Dimensions

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

## Measures

| Name | Type |
|------|------|
| `list_aggregate_restrictions` | string |

## Filters

- `name`

## Derived Table

```sql
#  sql:
  #  SELECT agg_restrictions.subaccount_id, cmm.customer_name, dt.name
  #  FROM (
  #      SELECT sa.subaccount_id, vdmr.customer_master_master_id, vdmr.distribution_type_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 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 subaccount_id, customer_master_master_id, NULL AS distribution_type_id
  #          FROM orchard_app_reporting_v2.art_relations_prod_art_relations.subaccount_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 %
```