anchorEpisodePlays is missing data

[woolfg]

there are only a few days and a lot of days are missing.

mysql> select * from anchorEpisodePlays where episode_id = "e1gqnf4" order by date;
+------------+------------+------------+-------+
| account_id | episode_id | date       | plays |
+------------+------------+------------+-------+
|          3 | e1gqnf4    | 2022-03-31 |    65 |
|          3 | e1gqnf4    | 2022-04-14 |    19 |
|          3 | e1gqnf4    | 2022-04-28 |    17 |
|          3 | e1gqnf4    | 2022-05-12 |     9 |
|          3 | e1gqnf4    | 2022-05-26 |     3 |
|          3 | e1gqnf4    | 2022-06-09 |     7 |
|          3 | e1gqnf4    | 2022-06-23 |     5 |
|          3 | e1gqnf4    | 2022-07-07 |     3 |
|          3 | e1gqnf4    | 2022-07-21 |     0 |
|          3 | e1gqnf4    | 2022-08-04 |     0 |
|          3 | e1gqnf4    | 2022-08-18 |     3 |
|          3 | e1gqnf4    | 2022-09-01 |     0 |
|          3 | e1gqnf4    | 2022-09-15 |     0 |
|          3 | e1gqnf4    | 2022-09-29 |     2 |
|          3 | e1gqnf4    | 2022-10-13 |     0 |
|          3 | e1gqnf4    | 2022-10-27 |     1 |
|          3 | e1gqnf4    | 2022-11-10 |     2 |
|          3 | e1gqnf4    | 2022-11-24 |     0 |
|          3 | e1gqnf4    | 2022-12-08 |     0 |
|          3 | e1gqnf4    | 2022-12-22 |     0 |
|          3 | e1gqnf4    | 2023-01-05 |     1 |
|          3 | e1gqnf4    | 2023-01-19 |     2 |
|          3 | e1gqnf4    | 2023-02-02 |     1 |
|          3 | e1gqnf4    | 2023-02-16 |     9 |
|          3 | e1gqnf4    | 2023-03-02 |    10 |
|          3 | e1gqnf4    | 2023-03-16 |     4 |
|          3 | e1gqnf4    | 2023-03-30 |     6 |
|          3 | e1gqnf4    | 2023-04-13 |     2 |
|          3 | e1gqnf4    | 2023-04-27 |     3 |
|          3 | e1gqnf4    | 2023-05-11 |     1 |
|          3 | e1gqnf4    | 2023-05-25 |     2 |
|          3 | e1gqnf4    | 2023-06-08 |     3 |
|          3 | e1gqnf4    | 2023-06-22 |     3 |
|          3 | e1gqnf4    | 2023-07-06 |     0 |
|          3 | e1gqnf4    | 2023-07-20 |     3 |
|          3 | e1gqnf4    | 2023-08-03 |     0 |
+------------+------------+------------+-------+
36 rows in set (0.00 sec)

[woolfg]

• fixtures are correct and everything works there
• problem is related to connector which doesn't allow to specify the timerange and the interval is not defined. both is needed for the api.

e.g. https://podcasters.spotify.com/pod/api/proxy/v3/analytics/episode/webEpisodeId:e1en10s/plays?&timeInterval=2628000&timeRangeStart=1689719762&timeRangeEnd=1692225362&limit=3

[woolfg]

after rolling out new conenctor we can truncate the table anchorEpisodePlays