9. Table & View Types

Table Types

Type	Fail-safe	Time Travel	Cost
Permanent	7 days	0-90 days	Standard
Transient	None	0-1 day	Lower
Temporary	None	0-1 day	Session-only

View Types

Standard View — Query definition, no storage
Materialized View — Pre-computed result, refreshed automatically
Secure View — Data hidden from users; predicates applied

CREATE TRANSIENT TABLE temp_data (id INT);
CREATE MATERIALIZED VIEW daily_sales AS
SELECT DATE_TRUNC('day', sale_ts), SUM(amount)
FROM sales GROUP BY 1;

✏️ Exercise: Create a permanent table, a transient table, and a materialized view. Compare the storage costs using ACCOUNT_USAGE views.