# View: dt_physical_dates

**View Name:** dt_physical_dates
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_PHYSICAL_DATES`
**File Path:** `dt_physical_dates.view.lkml`

## Overview

- **File Size:** 1631 bytes
- **Lines of Code:** 52
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- derived_table: {
- WITH fill_null_dates AS (
- SELECT release_id, store_id FROM orchard_app_reporting_v2.art_relations_prod_art_relations.product_physical

## Dimensions

| Name | Type |
|------|------|
| `product_id` | number |
| `supply_chain` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `release` | time |
| `sale_start` | time |
| `embargo` | time |

## Derived Table

```sql
#     sql:
# WITH fill_null_dates AS (
#     SELECT release_id, store_id FROM orchard_app_reporting_v2.art_relations_prod_art_relations.product_physical
#         CROSS JOIN ( SELECT DISTINCT store_id FROM orchard_app_reporting_v2.art_relations_prod_art_relations.product_physical_supply_chain_metadata )
# )
# SELECT
#     fnd.release_id AS product_id,
#     cmm.customer_name AS supply_chain,
#     ppscm.release_date AS release_date,
#     ppscm.sale_start_date,
#     ppscm.embargo_date
# FROM fill_null_dates fnd
#     LEFT JOIN (
#         SELECT *
#         FROM orchard_app_reporting_v2.art_relations_prod_art_relations.product_physical_supply_chain_metadata
#         WHERE NOT is_deleted
#     ) ppscm ON fnd.release_id = ppscm.product_id AND fnd.store_id = ppscm.store_id
#     INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master cmm ON fnd.store_id = cmm.customer_master_master_id ;;
#
```