morsapaes · April 25, 2022 10:23
diff --git a/hex_twitter_agg_hourly.sql b/hex_twitter_agg_hourly.sql
 CREATE MATERIALIZED VIEW tweets_hourly AS
 SELECT
  date_bin(interval '1 hours', created_at, '2022-03-22') AS time_bucket,
  COUNT(tweet_id) AS total_tweets
 FROM twitter_tweets
 GROUP BY 1;
	CREATE MATERIALIZED VIEW tweets_hourly AS
	SELECT
	date_bin(interval '1 hours', created_at, '2022-03-22') AS time_bucket,
	COUNT(tweet_id) AS total_tweets
	FROM twitter_tweets
	GROUP BY 1;