coldplay-spotify/project.visivo.yml at main · visivo-io/coldplay-spotify · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
name: "Coldplay Spotify Analytics"

sources:
  - name: spotify_db
    type: duckdb
    database: spotify_coldplay.duckdb

defaults:
  source_name: spotify_db

models:
  - name: artists_model
    sql: SELECT * FROM coldplay_data_20250718022923.artists

  - name: albums_model
    sql: SELECT * FROM coldplay_data_20250718022923.albums

  - name: tracks_model
    sql: SELECT * FROM coldplay_data_20250718022923.tracks

  - name: top_tracks_model
    sql: SELECT * FROM coldplay_data_20250718022923.top_tracks

traces:
  - name: follower_count_trace
    model: ref(artists_model)
    props:
      type: indicator
      value: ?{ sum(followers__total) }
      title:
        text: "Total Followers"

  - name: popularity_gauge_trace
    model: ref(artists_model)
    props:
      type: indicator
      value: ?{ avg(popularity) }
      mode: gauge
      gauge:
        axis:
          range: [0, 100]
      title:
        text: "Popularity Score"

  - name: albums_timeline_trace
    model: ref(albums_model)
    props:
      type: scatter
      x: ?{ release_date }
      y: ?{ total_tracks }
      text: ?{ name }
      marker:
        size: 10

  - name: top_tracks_table_trace
    model: ref(top_tracks_model)
    props:
      type: scatter
      x: ?{ rank }
      y: ?{ popularity }
      text: ?{ name }
      mode: markers

charts:
  - name: artist_metrics_chart
    traces:
      - ref(follower_count_trace)
      - ref(popularity_gauge_trace)

  - name: albums_chart
    traces:
      - ref(albums_timeline_trace)

  - name: top_tracks_chart
    traces:
      - ref(top_tracks_table_trace)

includes:
  - path: artist_overview.visivo.yml
  - path: album_analysis.visivo.yml
  - path: top_tracks.visivo.yml
  - path: musical_evolution.visivo.yml