Skip to content

Instantly share code, notes, and snippets.

@morsapaes

morsapaes/hex_twitter_agg.sql

Created April 25, 2022 10:11
Show Gist options
  • Save morsapaes/52fd7f09ede102b4ad270b8205160d59 to your computer and use it in GitHub Desktop.
Save morsapaes/52fd7f09ede102b4ad270b8205160d59 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hex_twitter_agg.sql
CREATE MATERIALIZED VIEW agg_tweets AS
SELECT COUNT(tweet) AS total_tweets,
username
FROM twitter_tweets_enriched
GROUP BY username;
CREATE MATERIALIZED VIEW agg_users AS
SELECT COUNT(twitter_id) AS total_tweets
FROM twitter_tweets
GROUP BY twitter_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment