# View: dt_release_country_of_origin_custom

**View Name:** dt_release_country_of_origin_custom
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_RELEASE_COUNTRY_OF_ORIGIN_CUSTOM`
**File Path:** `dt_release_country_of_origin_custom.view.lkml`

## Overview

- **File Size:** 788 bytes
- **Lines of Code:** 28
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: select upc, country_of_origin, c.country_code
- from ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASES r

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `country_code` | string |

## Derived Table

```sql
#     sql: select upc, country_of_origin, c.country_code
# from ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASES r
# inner join ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.COUNTRY c on r.country_of_origin = c.id
# where country_of_origin != 0
# and distribution_format_id NOT IN (1,57) ;;
#
```