# View: dt_album_art

**View Name:** dt_album_art
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `dt_album_art.view.lkml`

## Overview

- **File Size:** 2667 bytes
- **Lines of Code:** 86
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- af.id,af.ASSET_SUBTYPE,af.FILENAME,au.PRODUCT_ID
- FROM "ORCHARD_APP_REPORTING_V2"."PROD_OWS_ASSETS_OWS_ASSETS"."ASSET_FINAL" af

## Dimensions

| Name | Type |
|------|------|
| `PRODUCT_ID` | number |
| `ASSET_SUBTYPE` | string |
| `cover_url` | string |
| `xlarge_cover_url` | string |

## Derived Table

```sql
#     sql:
#     SELECT
#     af.id,af.ASSET_SUBTYPE,af.FILENAME,au.PRODUCT_ID
#     FROM "ORCHARD_APP_REPORTING_V2"."PROD_OWS_ASSETS_OWS_ASSETS"."ASSET_FINAL" af
#     INNER JOIN "ORCHARD_APP_REPORTING_V2"."PROD_OWS_ASSETS_OWS_ASSETS"."ASSET_UPLOAD" au ON au.id = af.asset_upload_id
#     WHERE au.api_version = 2 AND au.deleted = 0 and (af.asset_subtype = 'cover' or af.asset_subtype = 'xlarge_cover' );;
#
```