# View: hd_track_count_snowflake

**View Name:** hd_track_count_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Releases, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Orchard_App_Reporting_V2.Reportsdd_Direct_Delivery, Reportsdd_Direct_Delivery.Asset, Reportsdd_Direct_Delivery.Asset_Location + 3 more`
**File Path:** `hd_track_count_snowflake.view.lkml`

## Overview

- **File Size:** 2406 bytes
- **Lines of Code:** 82
- **Dimensions:** 2
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 5

## Comments & Notes

- This view pulls from the direct delivery db and finds the count of hd tracks on a release

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `hd_track_count` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Filters

- `asset_type_id_filter`
- `status_filter`
- `last_modified_filter`
- `physical_location_id_filter`
- `bits_per_sample_filter`

## Derived Table

```sql
sql: select hd_tracks.UPC
      ,count(filename) as hd_track_count
from (
SELECT
  TO_CHAR(TO_DATE(al.LAST_MODIFIED ), 'YYYY-MM-DD') AS last_modified,
  ald.FILENAME  AS filename,
  ald.FREQUENCY  AS frequency,
  ald.BITS_PER_SAMPLE  AS bits_per_sample,
  ald.AUDIO_CHANNELS  AS audio_channels,
  releases_snowflake.upc  As upc
FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases  AS releases_snowflake
LEFT JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.asset AS a ON a.UPC=releases_snowflake.upc
INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.asset_location AS al ON al.ASSET_ID=a.ASSET_ID
INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.storage_drive AS sd ON sd.STORAGE_DRIVE_ID=al.STORAGE_DRIVE_ID
INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.storage  AS s ON s.STORAGE_ID=sd.STORAGE_ID
INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.asset_location_detail AS ald ON ald.ASSET_LOCATION_ID=al.ASSET_LOCATION_ID
WHERE {% condition  asset_type_id_filter %
```