# View: dt_restrictions_label_substore

**View Name:** dt_restrictions_label_substore
**Table Source:** `INTELLIGENCE.DBT_PROD.RESTRICTIONS_LABEL_SUBSTORE`
**File Path:** `dt_restrictions_label_substore.view.lkml`

## Overview

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

## Comments & Notes

- Or, you could make this view a derived table, like this:
- derived_table: {
- sql: WITH dms_carveouts AS (

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | number |
| `subsotre_restrictions` | string |

## Derived Table

```sql
#    sql: WITH dms_carveouts AS (
#   SELECT
#    id AS vendor_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
#),
#active_carveouts AS (
#   SELECT
#     d.vendor_id,
#     d.dms_id
#   FROM dms_carveouts d
#   INNER JOIN intelligence.dbt_prod.active_vendor_contracts vw ON d.vendor_id = vw.vendor_id
# )
#
#SELECT
#    ac.vendor_id,
#    LISTAGG(DISTINCT cm.name, ', ') WITHIN GROUP (ORDER BY cm.name) AS substore_restrictions
#FROM active_carveouts ac
#INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master cm ON ac.dms_id = cm.customer_id
#GROUP BY 1;;
#
```