# View: delivery_history_snowflake

**View Name:** delivery_history_snowflake
**Table Source:** `orchard_app_reporting_v2.art_relations_prod_art_relations.delivery_history`
**File Path:** `delivery_history_snowflake.view.lkml`

## Overview

- **File Size:** 1781 bytes
- **Lines of Code:** 86
- **Dimensions:** 5
- **Measures:** 3
- **Dimension Groups:** 1
- **Filters:** 1

## Description

(Encoder 18 is Vector 2.5)

## Comments & Notes

- measure: delivered_yes_no {
- type: string
- label: "Delivered? (Yes/No)"

## Dimensions

| Name | Type |
|------|------|
| `delivery_id` | number |
| `encoder_id` | number |
| `upc` | string |
| `customer_master_master_id` | number |
| `package_size` | number |

## Measures

| Name | Type |
|------|------|
| `count_upc` | count_distinct |
| `max_date_delivered` | date |
| `min_date_delivered` | date |

## Dimension Groups

| Name | Type |
|------|------|
| `date_delivered` | time |

## Filters

- `encoder_id_filter`