stephan_taljaard
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.taylor
04/06/2021, 2:40 PMstephan_taljaard
04/06/2021, 5:03 PM