# View: dt_direct_delivery_max_last_updated

**View Name:** dt_direct_delivery_max_last_updated
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_DIRECT_DELIVERY_MAX_LAST_UPDATED`
**File Path:** `dt_direct_delivery_max_last_updated.view.lkml`

## Overview

- **File Size:** 997 bytes
- **Lines of Code:** 33
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- Or, you could make this view a derived table, like this:
- derived_table: {
- sql: SELECT

## Dimensions

| Name | Type |
|------|------|
| `store_id` | number |
| `last_delivery` | date_time |
| `first_delivery` | date_time |

## Derived Table

```sql
#    sql: SELECT
#    eqd.dms_master_master_id,
#    MAX(eqd.delivery_ended) AS last_delivery,
#    MIN(eqd.delivery_ended) AS first_delivery
#FROM orchard_app_reporting_v2.reportsdd_direct_delivery.encoding_queue_detail eqd
#INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.upc=eqd.upc
#INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_format df ON r.distribution_format_id=df.distribution_format_id
#WHERE df.context_type='digital'
#GROUP BY 1;;
#
```