# View: deleted_labels_snowflake_vn

**View Name:** deleted_labels_snowflake_vn
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Note, Art_Relations_Prod_Art_Relations.Vendor_Notes, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Vw_Dim_Abacus_Ar_Vendor + 2 more`
**File Path:** `deleted_labels_snowflake_vn.view.lkml`

## Overview

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

## Comments & Notes

- this view derives the deletion date by using the vendor_notes table and finding the date that the label offically had a status of the note_text below

## Dimensions

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

## Measures

| Name | Type |
|------|------|
| `count` | count |
| `count_deleted` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `note_date` | time |

## Derived Table

```sql
sql: select
        v.vendor_id,
        n.note_date,
        n.note_text
      from  royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v
      left join orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_notes vn on v.vendor_id=vn.vendor_id
      left join orchard_app_reporting_v2.art_relations_prod_art_relations.note n on vn.note_id = n.note_id
      where n.note_text = 'Label status changed from signed to deletion.'
      group by 1,2,3
       ;;
```