# View: deliverable_perf_rights_snowflake

**View Name:** deliverable_perf_rights_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_Relations.Releases, Dbt_Prod.Active_Vendor_Contracts, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations + 3 more`
**File Path:** `deliverable_perf_rights_snowflake.view.lkml`

## Overview

- **File Size:** 4050 bytes
- **Lines of Code:** 86
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `is_deliverable_vendor` | yesno |
| `is_deliverable_subaccount` | yesno |
| `is_deliverable_release` | yesno |

## Filters

- `territory`

## SQL Comments

- 1. CHECK DELIVERABLES (VENDOR)

## Derived Table

```sql
sql:
      SELECT
        r.release_id,
        IFNULL(deliver_vendor_territory.yes, FALSE)
          AS is_deliverable_vendor,
        IFNULL(deliver_vendor_territory.yes, FALSE)
          AND IFF(r.subaccount_id IS NULL, TRUE, IFNULL(deliver_subaccount_territory.yes, FALSE))
          AS is_deliverable_subaccount,
        IFNULL(deliver_vendor_territory.yes, FALSE)
          AND IFF(r.subaccount_id IS NULL, TRUE, IFNULL(deliver_subaccount_territory.yes, FALSE))
          AND IFNULL(restrict_release_territory.yes, TRUE)
          AS is_deliverable_release
      FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id
        INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id
        INNER JOIN intelligence.dbt_prod.active_vendor_contracts vw ON v.vendor_id = vw.vendor_id
-- 1. CHECK DELIVERABLES (VENDOR)
        LEFT JOIN (
            SELECT vc_flatten.id, TRUE AS yes
            FROM (
                SELECT id, TRY_TO_NUMBER(a.value::string) AS country_id
                FROM royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract,
                LATERAL FLATTEN(INPUT => SPLIT(royalty_collection_territory, ',')) a
              ) vc_flatten
              LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.country c ON vc_flatten.country_id = c.id
              WHERE {% condition territory %
```