# View: vendor_dms_restriction_snowflake

**View Name:** vendor_dms_restriction_snowflake
**Table Source:** `Derived from: Prod.Vw_Dim_Abacus_Ar_Vendor_Contract, Royalty_Accounting_Reporting, Royalty_Accounting_Reporting.Prod`
**File Path:** `vendor_dms_restriction_snowflake.view.lkml`

## Overview

- **File Size:** 1546 bytes
- **Lines of Code:** 57
- **Dimensions:** 3
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- measure: concat_count {
- label: "Count Restrictions (Labeled)"
- type: string

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `id` | number |
| `dms_id` | number |

## Measures

| Name | Type |
|------|------|
| `count` | number |
| `list_restrictions` | string |

## Derived Table

```sql
sql: SELECT
          id,
          TRY_TO_NUMBER(a.value::string) AS dms_id,
          CONCAT(id, dms_id) AS primary_key
      FROM royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract,
          LATERAL FLATTEN(INPUT => SPLIT(dms_carve_out, ',')) a
      WHERE primary_key IS NOT NULL
       ;;
```