Some ideas for viz pipeline

This query runs in a minute or two, with minimal resources. It generates 1/4 billion rows constituting a MinRTT histogram for each hour and each host.

SELECT
_partitiontime as pt,
timestamp_trunc(log_time, HOUR) as hour,
connection_spec.server_hostname as host,
ROUND(log(web100_log_entry.snap.MinRTT+1), 1) AS bucket,
round(avg(web100_log_entry.snap.MinRTT), 1) as avg,
COUNT(*) AS COUNT
FROM mlab-oti.base_tables.ndt
GROUP BY pt, hour, host, bucket