# View: mkt_priority_snowflake

**View Name:** mkt_priority_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Country, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Mkt_Priority_All`
**File Path:** `mkt_priority_snowflake.view.lkml`

## Overview

- **File Size:** 1767 bytes
- **Lines of Code:** 80
- **Dimensions:** 8
- **Measures:** 3
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- dimension: id {
- hidden: yes
- type: number

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `priority` | string |
| `country_id` | number |
| `release_id` | number |
| `abbrivation` | string |
| `continent` | string |
| `country_code` | string |
| `name` | string |

## Measures

| Name | Type |
|------|------|
| `priority_list` | string |
| `priority_list_country` | string |
| `country_code_list` | string |

## SQL Comments

- mkt_priority.id,

## Derived Table

```sql
sql:
     select
            --mkt_priority.id,
            mkt_priority_all.upc,
            mkt_priority_all.priority,
            mkt_priority_all.country_id,
            mkt_priority_all.release_id,
            country.abbrivation,
            country.continent,
            country.country_code,
            country.name
     from facts.prod.mkt_priority_all
     left join orchard_app_reporting_v2.art_relations_prod_art_relations.country  on mkt_priority_all.country_id=country.id
     group by 1,2,3,4,5,6,7,8;;
```