maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_reprocess_dw()
Parameters
Name
Type
Mode
Definition
DECLARE stored_ms varchar := 'unknown'; current_ms varchar := 'unknown'; starttime_ms timestamptz; endtime_ms timestamptz; rec RECORD; BEGIN FOR rec IN SELECT e.date_key, e.serialnumber FROM tmp.etl_mayo e LOOP RAISE NOTICE '%', rec.date_key; select * from dblink('dbname=maya','SELECT * FROM tmp.etl_mayo') limit 1; --SELECT FROM fact_unit_activity fua JOIN dim_unit u ON u.unit_key = fua.unit_key --WHERE fua.date_key BETWEEN '20200401' AND '20200601' --AND u.serialnumber = rec.serialnumber --ORDER BY fua.date_key; END LOOP; END;