17 lines
388 B
SQL
17 lines
388 B
SQL
|
{{ config(
|
||
|
|
materialized='table',
|
||
|
|
schema='gold'
|
||
|
|
) }}
|
||
|
|
|
||
|
|
SELECT
|
||
|
|
stasiun_id,
|
||
|
|
nama_stasiun,
|
||
|
|
CAST(recorded_at AS DATE) AS observation_date,
|
||
|
|
AVG(pm25_value) AS avg_pm25,
|
||
|
|
MAX(pm25_value) AS max_pm25,
|
||
|
|
AVG(pm10_value) AS avg_pm10,
|
||
|
|
MAX(pm10_value) AS max_pm10,
|
||
|
|
CURRENT_TIMESTAMP AS refreshed_at_gold
|
||
|
|
FROM {{ ref('silver_spku_sensor_clean') }}
|
||
|
|
GROUP BY 1, 2, 3
|