# View: dt_artist_genre

**View Name:** dt_artist_genre
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_ARTIST_GENRE`
**File Path:** `dt_artist_genre.view.lkml`

## Overview

- **File Size:** 1093 bytes
- **Lines of Code:** 37
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- SELECT base.artist_id, g.genre AS artist_genre
- ROW_NUMBER() OVER (PARTITION BY artist_id ORDER BY releases,max_date DESC) AS rank

## Dimensions

| Name | Type |
|------|------|
| `artist_id` | number |
| `artist_genre` | string |

## Derived Table

```sql
#    sql:
#    SELECT base.artist_id, g.genre AS artist_genre
#    FROM (
#        SELECT
#            artist_id,
#            genre_id,
#            ROW_NUMBER() OVER (PARTITION BY artist_id ORDER BY releases,max_date DESC) AS rank
#        FROM (
#            SELECT
#                artist_id,
#                genre_id,
#                COUNT(DISTINCT release_id) AS releases,
#                MAX(sale_start_date) AS max_date
#            FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases
#            WHERE release_status = 'in_content' AND not_for_distribution = 'N'
#            GROUP BY 1,2
#        )
#    ) base
#        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.genre g ON base.genre_id = g.genre_id
#    WHERE rank = 1 ;;
#
```