Fwd: New DSMO rolling year table

[Blake Imsland]

Forwarding to the correct group.

---------- Forwarded message ----------
From: Blake Imsland <bimsland at mozilla.com>
Date: Fri, Feb 9, 2018 at 11:07 AM
Subject: New DSMO rolling year table
To: fx-data-platform <fx-data-platform at mozilla.com>, fx-data-dev at mozilla.com


Hi All,

If you are a regular consumer of the DSMO data source and the
download_stats table you may have seen some errors recently regarding
Redshift running out of memory. The long term solution is to get this data
moved into parquet and consume it via Presto / Athena but as a work around
for the time being we've created a new table, "download_stats_year", that
contains the rolling last 365 days of data.

If you're still seeing issues or have any questions feel free to reach out
to me via whatever communication channel you're most comfortable with [1].

Cheers,
Blake

[1] https://tools.ietf.org/html/rfc1149
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.mozilla.org/pipermail/fx-data-dev/attachments/20180209/f4ad662b/attachment.html>