# View: releases_log_snowflake

**View Name:** releases_log_snowflake
**Table Source:** `orchard_app_reporting_v2.art_relations_prod_art_relations_log.releases_log`
**File Path:** `releases_log_snowflake.view.lkml`

## Overview

- **File Size:** 10603 bytes
- **Lines of Code:** 592
- **Dimensions:** 92
- **Measures:** 2
- **Dimension Groups:** 2
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `release_status` | string |
| `sale_start_date` | date |
| `keywords` | string |
| `wholesale_price_tier` | string |
| `referral_id` | string |
| `promobox_no` | string |
| `album_download` | string |
| `_metadata_log_position` | number |
| `_metadata__uuid` | string |
| `_metadata_deleted` | string |
| `_metadata_timestamp` | string |
| `_metadata__timestamp` | string |
| `_metadata_log_file` | string |
| `_metadata_database` | string |
| `_metadata_snapshot_size` | string |
| `_metadata_snapshot_id` | number |
| `original_release_date` | date |
| `log_action` | string |
| `project_id` | number |
| `product_type_id` | number |
| `release_id` | number |
| `unknown_artist` | string |
| `format` | string |
| `promocode` | string |
| `physical_release_date` | date |
| `rsd_comment` | string |
| `production_co` | string |
| `upc` | number |
| `production_number` | number |
| `channel_id` | number |
| `trackdown_black_list` | string |
| `deletions` | string |
| `ingestion_completed` | string |
| `product_code` | string |
| `product_subtype_id` | number |
| `est` | string |
| `network` | string |
| `language_id` | string |
| `label` | string |
| `version` | string |
| `preorder_date` | date |
| `sellprice` | number |
| `new_release` | string |
| `europe_public_domain` | string |
| `amd_id` | string |
| `digital_only` | string |
| `compilation` | string |
| `short_synopsis` | string |
| `date_added_remove` | string |
| `c_line` | string |
| `tms_id` | string |
| `distribution_format_id` | number |
| `subtitle_language_id` | string |
| `vod_start_date` | date |
| `applfees` | number |
| `sync_only` | string |
| `manufacturer_upc` | string |
| `country_of_origin` | number |
| `meta_language` | string |
| `not_for_distribution` | string |
| `priority` | number |
| `vendor_release_identifier` | string |
| `additional_id` | number |
| `territory` | string |
| `int_mkt_manager` | number |
| `promos_number` | number |
| `season` | number |
| `brand` | string |
| `special_instructions` | string |
| `karaoke` | string |
| `display_upc` | string |
| `distribution` | string |
| `release_name` | string |
| `display` | string |
| `genre_id` | number |
| `vod` | string |
| `dracatalog` | number |
| `genre_note` | string |
| `promo_upc` | number |
| `itunes_previewable` | string |
| `subaccount_id` | number |
| `artist_id` | number |
| `vendor_catalog_number` | string |
| `orig_release_year` | number |
| `description` | string |
| `theatrical_release_date` | date |
| `download_price` | number |
| `listprice` | number |
| `product_format` | string |
| `episode` | number |
| `release_date` | date |
| `original_digital_release_date` | date |

## Measures

| Name | Type |
|------|------|
| `count` | count |
| `min_log_timestamp` | date |

## Dimension Groups

| Name | Type |
|------|------|
| `last_updated` | time |
| `log_timestamp` | time |

