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.4.3", "url": "https://github.com/ForomePlatform/dorieh", "commit": "d5d46ee8f87cba7c46356cc5105c37d98eb99086"}. Created at 2026-07-12 23:59:23.778993';

---

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