# View: dt_agg_restrictions_release_substore

**View Name:** dt_agg_restrictions_release_substore
**Table Source:** `INTELLIGENCE.DBT_PROD.RESTRICTIONS_RELEASE_SUBSTORE`
**File Path:** `dt_agg_restrictions_release_substore.view.lkml`

## Overview

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

## Comments & Notes

- derived_table: {
- SELECT agg_restrictions.release_id, cm.name
- SELECT r.release_id, vdr.dms_id

## Dimensions

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

## Measures

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

## Derived Table

```sql
#  sql:
  #  SELECT agg_restrictions.release_id, cm.name
  #  FROM (
  #      SELECT r.release_id, vdr.dms_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 (
  #              SELECT id, TRY_TO_NUMBER(a.value::string) AS dms_id
  #              FROM orchard_app_reporting_v2.art_relations_prod_art_relations.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 r.release_id, sdr.dms_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_restriction sdr ON r.subaccount_id = sdr.subaccount_id
  #          WHERE r.subaccount_id IS NOT NULL
  #      UNION ALL
  #          SELECT release_id, dms_customer_id AS dms_id
  #          FROM orchard_app_reporting_v2.art_relations_prod_art_relations.release_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 ;;
  #
```