# View: dt_proper_genre_subgenre_mapping

**View Name:** dt_proper_genre_subgenre_mapping
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_PROPER_GENRE_SUBGENRE_MAPPING`
**File Path:** `dt_proper_genre_subgenre_mapping.view.lkml`

## Overview

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

## Comments & Notes

- derived_table: {
- sql: WITH a AS (SELECT
- rs.release_id,

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `primarygenre` | string |
| `secondarygenre` | string |

## Derived Table

```sql
#     sql: WITH a AS (SELECT
#     rs.release_id,
#     dmg.dms_master_genre AS primarygenre,
#     NULL AS secondarygenre
# FROM orchard_app_reporting_v2.art_relations_prod_art_relations.dms_master_genre dmg
# INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.dms_genre_mapping dgm ON dmg.dms_master_genre_id = dgm.dms_master_genre_id
# INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.release_subgenre rs ON dgm.orchard_subgenre_id = rs.subgenre_id
# WHERE dmg.customer_master_master_id = 696),

# b AS (SELECT
#     rs.release_id,
#     dms_master_genre AS primarygenre,
#     dms_master_subgenre AS secondarygenre
# FROM orchard_app_reporting_v2.art_relations_prod_art_relations.dms_subgenre_mapping dgm
# INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.dms_master_subgenre dmg ON dmg.dms_master_subgenre_id = dgm.dms_master_subgenre_id
# INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.dms_master_genre g ON g.dms_master_genre_id=dmg.dms_master_genre_id
# INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.release_subgenre rs ON rs.subgenre_id=dgm.orchard_subgenre_id
# WHERE g.customer_master_master_id=696)

# SELECT
#     COALESCE(a.release_id,b.release_id) AS release_id,
#     COALESCE(a.primarygenre, b.primarygenre) AS primarygenre,
#     COALESCE(a.secondarygenre, b.secondarygenre) AS secondarygenre
# FROM a
# FULL OUTER JOIN b ON a.release_id=b.release_id
#       ;;
#
```