# View: dt_youtube_multi_asset_isrc_join

**View Name:** dt_youtube_multi_asset_isrc_join
**Table Source:** `Derived from: Prod.Staging_Raw_Youtube_Monthly_Claim_Raw_V1_1`
**File Path:** `views/dt_youtube_multi_asset_isrc_join.view.lkml`

## Overview

- **File Size:** 2060 bytes
- **Lines of Code:** 94
- **Dimensions:** 7
- **Measures:** 1
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `video_id` | string |
| `asset_id` | string |
| `custom_id` | string |
| `upc` | string |
| `isrc` | string |
| `content_type` | string |
| `videorows` | number |

## Measures

| Name | Type |
|------|------|
| `revenue` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `download_date` | time |

## Derived Table

```sql
sql: with vid as (
      select download_date, VIDEO_ID, ASSET_ID, CUSTOM_ID, ISRC, UPC, CONTENT_TYPE, sum(partner_revenue) as REV  from facts.prod.staging_raw_youtube_monthly_claim_raw_v1_1
      where to_date(download_date)= {% parameter filter_download_date %
```