# View: cm_raw_data_spotify_artist

**View Name:** cm_raw_data_spotify_artist
**Table Source:** `intelligence.dbt_prod.stg_cm_spotify_artist_clean`
**File Path:** `cm_raw_data_spotify_artist.view.lkml`

## Overview

- **File Size:** 2668 bytes
- **Lines of Code:** 109
- **Dimensions:** 9
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- derived_table: {
- from (Select cm_artist as cma, max(followers_latest) as max_followers
- from chartmetric.raw_data.spotify_artist

## Dimensions

| Name | Type |
|------|------|
| `id` | number |
| `spotify_artist_id` | string |
| `genres` | string |
| `popularity_latest` | number |
| `followers_latest` | number |
| `artist_name` | string |
| `cm_artist` | number |
| `description` | string |
| `artwork_url` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `last_updated` | time |

## Derived Table

```sql
#     sql:
#     Select *
# from (Select cm_artist as cma, max(followers_latest) as max_followers
#       from chartmetric.raw_data.spotify_artist
#       group by 1) as dta
# inner join chartmetric.raw_data.spotify_artist sa on dta.cma = sa.cm_artist
#             and dta.max_followers = sa.followers_latest ;;
#
```