Using GENERATE_ARRAY for Histograms and More — When you stumble upon your first task of creating a histogram within BigQuery you might approach it with a simple GROUP BY, something like: SELECT
hour,
COUNT(*) AS num_accesses
FROM
accesses
GROUP BY
hour
ORDER BY
hour This is fine, it does a decent job and would earn you a…