# View: deleted_releases_snowflake

**View Name:** deleted_releases_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Full_Deletions, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `deleted_releases_snowflake.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |

## Measures

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

## Dimension Groups

| Name | Type |
|------|------|
| `delete_date` | time |

## Derived Table

```sql
sql:
    select fd2.upc
    , max(fd2.date_deleted) as delete_date
from orchard_app_reporting_v2.art_relations_prod_art_relations.full_deletions fd2
where fd2.action = 'delete'
group by 1 ;;
```