Create a table named metrics for analytics with the following columns: metric_id (INTEGER), sensor_id (INTEGER), metric_value (DECIMAL(15,4)), recorded_at (TIMESTAMP). Use columnar storage with compression: WITH (appendoptimized=true, orientation=column, compresstype=zstd).
Sign in to solve
Start Solving