ambitious-accountant-73135
04/06/2021, 2:24 PMSELECT TagName, DateTime, Value
FROM History
WHERE TagName LIKE '{tag}'
AND DateTime > '{from_date}' AND DateTime <= '{to_date}'
AND wwRetrievalMode = 'Average' AND wwResolution = {res_millisec}
The query then returns 30-minute aggregate data.
For testing, I can hard-code a tag
, resolution
, etc.
I got thus far setting up my meltano.yml
following the tutorial, but don't know what's next.
When running, it will replicate the whole table, which is not what I require.salmon-salesclerk-77709
04/06/2021, 2:40 PMambitious-accountant-73135
04/06/2021, 5:03 PM