Aggregate View Creation

[cordialApple]

Create 1 aggregated views for our database utilitizing the sensor_readings table. They will typically follow this convention:

CREATE MATERIALIZED VIEW split_sensor_data_by_filter
WITH (timescaledb.continuous) AS
SELECT
(LOGIC)

These views will aggregate values, making API ingestion easier for our dashboard, increasing efficiency.