# View: release_level_third_party_publisher_snowflake

**View Name:** release_level_third_party_publisher_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Releases, Art_Relations_Prod_Art_Relations.Track, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `release_level_third_party_publisher_snowflake.view.lkml`

## Overview

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

## Dimensions

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

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Derived Table

```sql
sql: select r.release_id
        , case when type_count=2
               THEN 'both'
               ELSE t.third_party_publisher
               END AS release_third_party_publisher
from orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
left join orchard_app_reporting_v2.art_relations_prod_art_relations.track t on t.release_id=r.release_id
left join (
    select r.release_id
            ,count(distinct t.third_party_publisher) as type_count
    from orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
    left join orchard_app_reporting_v2.art_relations_prod_art_relations.track t on t.release_id=r.release_id
    group by 1
        ) track_type_count on track_type_count.release_id=r.release_id
where release_third_party_publisher is not null
group by 1, 2
 ;;
```