Skip to content

Instantly share code, notes, and snippets.

@ldenson11 ldenson11/windowquery.sql Secret
Created Oct 25, 2019

Embed
What would you like to do?
SELECT SUM(CAST(amount AS numeric)) AS payment_volume,
CAST(TUMBLE_END(eventTimestamp, interval '1' hour) AS varchar) AS ts
FROM payments
GROUP BY TUMBLE(eventTimestamp, interval '1' hour);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.