If I'm doing simple run tap-x target-x should I ha...
# getting-started
d
If I'm doing simple run tap-x target-x should I have a state update in my database or not?
t
If you are doing
meltano run
then I don't think you will. If you do
meltano elt
then yes.
p
@dima_petukhov check out https://docs.meltano.com/guide/integration#incremental-replication-state. Yeah you should see state in the DB. What tap are you using? Not ever tap supports incremental extraction
t
Actually I think I have that backwards, don't I? 🤣
p
Yeah I think so, for
elt
you pass in
--state-id
to store it but
run
auto generates a state ID for you
t
With
elt
you have to specify
--state-id
to have state tracked IIRC.
d
@pat_nadolny I'm using tap-shopify (singer)
someone said that meltano elt is deprecated is that true? That's why I'm using run
p
@dima_petukhov
run
is the newer more flexible command that we general recommend but
elt
is still supported and is not deprecated
d
Thank you!
p
Has your sync completed successfully?
d
It's still running
p
At the end of the run you should see it updated
I'd also use the
state get
command vs directly reading the DB because meltano does some magic with state to merge partially updated streams in case something fails
i.e. a success then partial completion gets merged into a combination of the 2 vs just reverting to the last success
d
I didn't know that, will use that for sure