search

mozilla / fxa-activity-metrics

A server for managing the Firefox Accounts metrics database and pipeline
1 stars 3 forks source link

Debigulate flow_events #105

Closed philbooth closed 6 years ago

philbooth commented 6 years ago

Related to #104.

This includes the three less contentious changes to reduce the amount of data we store in Redshift. They don't break any queries as far as I can make out.

@jbuck r?

(if you think things look okay from a syntax standpoint I'll do a trial run import before merging, just to make sure everything still works)

philbooth commented 6 years ago

These landed:

fxa=# select count(*) from flow_events where type like 'flow.continued%';
 count
-------
     0
(1 row)

fxa=# select count(*) from flow_events where type like 'flow.experiment%';
 count
-------
     0
(1 row)

fxa=# drop table strict_daily_multi_device_users;
DROP TABLE