# View: map_subgenre_from_genre_snowflake

**View Name:** map_subgenre_from_genre_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Dms_Master_Genre, Art_Relations_Prod_Art_Relations.Dms_Master_Subgenre, Art_Relations_Prod_Art_Relations.Dms_Subgenre_Mapping, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `map_subgenre_from_genre_snowflake.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `customer_master_master_id` | number |
| `orchard_subgenre_id` | number |
| `dms_master_subgenre` | string |

## Derived Table

```sql
sql:
SELECT dmg.customer_master_master_id, map_subgenre.orchard_subgenre_id, dms.dms_master_subgenre
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_master_subgenre dms ON dmg.dms_master_genre_id = dms.dms_master_genre_id
  INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.dms_subgenre_mapping map_subgenre ON dms.dms_master_subgenre_id = map_subgenre.dms_master_subgenre_id ;;
```