Hi. Newbie question: Is Meltano only for whole DB/...
# announcements
s
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.
t
are you passing it a state file?
s
No. I'll read up on it and give feedback.