# View: releases_snowflake

**View Name:** releases_snowflake
**Table Source:** `ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASES`
**File Path:** `releases_snowflake.view.lkml`

## Overview

- **File Size:** 12131 bytes
- **Lines of Code:** 598
- **Dimensions:** 86
- **Measures:** 3
- **Dimension Groups:** 11
- **Filters:** 0

## Comments & Notes

- hidden: true
- hidden: true
- hidden: true

## Dimensions

| Name | Type |
|------|------|
| `distribution_format_id` | number |
| `vendor_release_identifier` | string |
| `additional_id` | number |
| `album_download` | string |
| `amd_id` | string |
| `applfees` | number |
| `artist_id` | number |
| `brand` | string |
| `c_line` | string |
| `channel_id` | number |
| `compilation` | string |
| `country_of_origin` | number |
| `deletions` | string |
| `description` | string |
| `digital_only` | string |
| `display` | string |
| `display_upc` | string |
| `display_upc_quotes` | string |
| `distribution` | string |
| `download_price` | number |
| `dracatalog` | number |
| `episode` | number |
| `est` | string |
| `europe_public_domain` | string |
| `format` | string |
| `genre_id` | number |
| `genre_note` | string |
| `int_mkt_manager` | number |
| `itunes_previewable` | string |
| `karaoke` | string |
| `keywords` | string |
| `label` | string |
| `language_id` | string |
| `listprice` | number |
| `manufacturer_upc` | string |
| `meta_language` | string |
| `network` | string |
| `new_release` | string |
| `not_for_distribution` | string |
| `orig_release_year` | number |
| `is_priority` | yesno |
| `priority` | number |
| `product_code` | string |
| `product_code_upper_case` | string |
| `product_format` | string |
| `product_subtype_id` | number |
| `product_type_id` | number |
| `production_co` | string |
| `production_number` | number |
| `promo_upc` | number |
| `promobox_no` | string |
| `promocode` | string |
| `promos_number` | number |
| `referral_id` | string |
| `release_id` | number |
| `release_name` | string |
| `release_name_upper_case` | string |
| `release_status` | string |
| `rsd_comment` | string |
| `season` | number |
| `sellprice` | number |
| `short_synopsis` | string |
| `subaccount_id` | number |
| `subtitle_language_id` | string |
| `special_instructions` | string |
| `sync_only` | string |
| `territory` | string |
| `tms_id` | string |
| `trackdown_black_list` | string |
| `unknown_artist` | string |
| `upc` | string |
| `upc_link` | string |
| `upc_album_art` | string |
| `upc_album_art_expand` | string |
| `upc_linked_image` | string |
| `combined_upc` | string |
| `upc_join` | string |
| `vendor_catalog_number` | string |
| `version` | string |
| `delivered_version` | string |
| `vod` | string |
| `wholesale_price_tier` | string |
| `project_id` | number |
| `is_active_release` | yesno |
| `is_not_for_distribution` | yesno |
| `sales_vs_release` | yesno |

## Measures

| Name | Type |
|------|------|
| `max_sale_start_date` | date |
| `count` | count_distinct |
| `release_id_count` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `date_added_remove` | time |
| `ingestion_completed` | time |
| `last_updated` | time |
| `original_digital_release` | time |
| `original_release` | time |
| `physical_release` | time |
| `preorder` | time |
| `release` | time |
| `sale_start` | time |
| `theatrical_release` | time |
| `vod_start` | time |