# View: dt_playlist_track_fit

**View Name:** dt_playlist_track_fit
**Table Source:** `Derived from: Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_Up, Dbt_Prod.Spotify_Track_Audio_Features, Intelligence.Dbt_Prod`
**File Path:** `dt_playlist_track_fit.view.lkml`

## Overview

- **File Size:** 21154 bytes
- **Lines of Code:** 701
- **Dimensions:** 46
- **Measures:** 39
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- Playlist Dimensions and Measures
- Track Dimensions and Measures
- Track Dimensions and Measures

## Dimensions

| Name | Type |
|------|------|
| `storeid` | number |
| `cm_playlist_id` | number |
| `playlist_name` | string |
| `playlist_url` | string |
| `playlist_uri` | string |
| `playlist_avg_acousticness` | number |
| `playlist_stddev_acousticness` | number |
| `playlist_avg_danceability` | number |
| `playlist_stddev_danceability` | number |
| `playlist_avg_energy` | number |
| `playlist_stddev_energy` | number |
| `playlist_avg_instrumentalness` | number |
| `playlist_stddev_instrumentalness` | number |
| `playlist_avg_liveness` | number |
| `playlist_stddev_liveness` | number |
| `playlist_avg_loudness` | number |
| `playlist_stddev_loudness` | number |
| `playlist_avg_speechiness` | number |
| `playlist_stddev_speechiness` | number |
| `playlist_avg_tempo` | number |
| `playlist_stddev_tempo` | number |
| `playlist_avg_duration_ms` | number |
| `playlist_stddev_duration_ms` | number |
| `playlist_avg_key` | number |
| `playlist_stddev_key` | number |
| `playlist_avg_mode` | number |
| `playlist_stddev_mode` | number |
| `playlist_avg_time_signature` | number |
| `playlist_stddev_time_signature` | number |
| `playlist_avg_valence` | number |
| `playlist_stddev_valence` | number |
| `track_isrc` | string |
| `track_uri` | string |
| `track_acousticness` | number |
| `track_danceability` | number |
| `track_duration_ms` | number |
| `track_energy` | number |
| `track_instrumentalness` | number |
| `track_key` | number |
| `track_liveness` | number |
| `track_loudness` | number |
| `track_mode` | number |
| `track_speechiness` | number |
| `track_tempo` | number |
| `track_time_signature` | number |
| `track_valence` | number |

## Measures

| Name | Type |
|------|------|
| `playlist_avg_acousticness_measure` | average |
| `playlist_stddev_acousticness_measure` | average |
| `playlist_avg_danceability_measure` | average |
| `playlist_stddev_danceability_measure` | average |
| `playlist_avg_energy_measure` | average |
| `playlist_stddev_energy_measure` | average |
| `playlist_avg_instrumentalness_measure` | average |
| `playlist_stddev_instrumentalness_measure` | average |
| `playlist_avg_liveness_measure` | average |
| `playlist_stddev_liveness_measure` | average |
| `playlist_avg_loudness_measure` | average |
| `playlist_stddev_loudness_measure` | average |
| `playlist_avg_speechiness_measure` | average |
| `playlist_stddev_speechiness_measure` | average |
| `playlist_avg_tempo_measure` | average |
| `playlist_stddev_tempo_measure` | average |
| `playlist_avg_duration_ms_measure` | average |
| `playlist_stddev_duration_ms_measure` | average |
| `playlist_avg_key_measure` | average |
| `playlist_stddev_key_measure` | average |
| `playlist_avg_mode_measure` | average |
| `playlist_stddev_mode_measure` | average |
| `playlist_avg_time_signature_measure` | average |
| `playlist_stddev_time_signature_measure` | average |
| `playlist_avg_valence_measure` | average |
| `playlist_stddev_valence_measure` | average |
| `track_acousticness_in_playlist_range` | string |
| `track_danceability_in_playlist_range` | string |
| `track_energy_in_playlist_range` | string |
| `track_duration_ms_in_playlist_range` | string |
| `track_instrumentalness_in_playlist_range` | string |
| `track_key_in_playlist_range` | string |
| `track_liveness_in_playlist_range` | string |
| `track_loudness_in_playlist_range` | string |
| `track_mode_in_playlist_range` | string |
| `track_speechiness_in_playlist_range` | string |
| `track_tempo_in_playlist_range` | string |
| `track_time_signature_in_playlist_range` | string |
| `track_valence_in_playlist_range` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `recorded_date` | time |

## Derived Table

```sql
sql:


      select
          paf.date as recorded_date,
          paf.store_id as store_id,
          paf.cm_playlist_id as cm_playlist_id,
          paf.playlist_name as playlist_name,
          paf.playlist_url as playlist_url,
          paf.playlist_uri as playlist_uri,
          paf.avg_acousticness as playlist_avg_acousticness,
          paf.stddev_acousticness as playlist_stddev_acousticness,
          paf.avg_danceability as playlist_avg_danceability,
          paf.stddev_danceability as playlist_stddev_danceability,
          paf.avg_energy as playlist_avg_energy,
          paf.stddev_energy as playlist_stddev_energy,
          paf.avg_instrumentalness as playlist_avg_instrumentalness,
          paf.stddev_instrumentalness as playlist_stddev_instrumentalness,
          paf.avg_liveness as playlist_avg_liveness,
          paf.stddev_liveness as playlist_stddev_liveness,
          paf.avg_loudness as playlist_avg_loudness,
          paf.stddev_loudness as playlist_stddev_loudness,
          paf.avg_speechiness as playlist_avg_speechiness,
          paf.stddev_speechiness as playlist_stddev_speechiness,
          paf.avg_tempo as playlist_avg_tempo,
          paf.stddev_tempo as playlist_stddev_tempo,
          paf.avg_duration_ms as playlist_avg_duration_ms,
          paf.stddev_duration_ms as playlist_stddev_duration_ms,
          paf.avg_key as playlist_avg_key,
          paf.stddev_key as playlist_stddev_key,
          paf.avg_mode as playlist_avg_mode,
          paf.stddev_mode as playlist_stddev_mode,
          paf.avg_time_signature as playlist_avg_time_signature,
          paf.stddev_time_signature as playlist_stddev_time_signature,
          paf.avg_valence as playlist_avg_valence,
          paf.stddev_valence as playlist_stddev_valence,

          af.isrc as track_isrc,
          af.uri as track_uri,
          af.acousticness as track_acousticness,
          af.danceability as track_danceability,
          af.duration_ms as track_duration_ms,
          af.energy as track_energy,
          af.instrumentalness as track_instrumentalness,
          af.key as track_key,
          af.liveness as track_liveness,
          af.loudness as track_loudness,
          af.mode as track_mode,
          af.speechiness as track_speechiness,
          af.tempo as track_tempo,
          af.time_signature as track_time_signature,
          af.valence as track_valence


      from INTELLIGENCE.DBT_PROD.spotify_editorial_audio_feature_roll_up paf
      cross join INTELLIGENCE.DBT_PROD.SPOTIFY_TRACK_AUDIO_FEATURES af

      where
       af.isrc = {% parameter input_isrc %
```