Materialized view gold_temperature_by_state

Overview for gold_temperature_by_state

Temperature variations by US State

Aggregated from silver_temperature on On us_state, date

Primary Key: us_state, date

SQL/DDL Statement

CREATE materialized view  gold_temperature_by_state AS
SELECT
    us_state,
	date,
	MAX(tmmx) - MIN(tmmx) AS t_span,
	AVG(temperature_in_C) AS t_mean_in_C,
	AVG(temperature_in_F) AS t_mean_in_F
FROM silver_temperature

WHERE us_state IS NOT NULL AND date IS NOT NULL
GROUP BY us_state,date;

COMMENT ON materialized view gold_temperature_by_state IS 'CREATED BY Dorieh: {"version": "0.5.1.post2", "url": "file://<local checkout>", "commit": null}. Created at 2026-09-12 15:03:54.874348';

---

Columns:

Column Name	Column Type	Datatype
date	grouping	string
t_mean_in_c	computed	float
t_mean_in_f	computed	float
t_span	computed	float
us_state	grouping	string