Hi, from where does meltano pick up state ? from .meltano or postgres DB ? since even clearing all data from postgres DB it is maintaining state

Maybe you want to take a look into the State backend docs? https://docs.meltano.com/concepts/state_backends#undefined and in general to clear state you can simply use the CLI: https://docs.meltano.com/reference/command-line-interface#clear. By default your state data will be stored in a SQLite database inside the .meltano folder (https://docs.meltano.com/concepts/project#system-database). Unless you configure it as outlined above to be stored in some external database (e.g. a postgreSQL db). So it does depend on how you set it up.

Hi @Sven Balnojan i have a similar issue around the state and have posted recently a message on the channel ( https://meltano.slack.com/archives/C01TCRBBJD7/p1668647222468409) . I was trying to follow the urls you posted above but for now with no joy. The interesting bit is that if i run this from the UI, the state seems to be set, if i run it on docker using meltano run, it tries to do a full import every time.