https://meltano.com/ logo
#announcements
Title
# announcements
a

ambitious-accountant-73135

04/06/2021, 2:24 PM
Hi. Newbie question: Is Meltano only for whole DB/table replication? I have a timeseries MSSQL db with raw data saved in millisecond-resolution. I need to perform this query once per day for each "tag" (sensor name):
Copy code
SELECT 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.
s

salmon-salesclerk-77709

04/06/2021, 2:40 PM
are you passing it a state file?
a

ambitious-accountant-73135

04/06/2021, 5:03 PM
No. I'll read up on it and give feedback.
👍 1