Hey everyone, We have a tap-posgres which has been working fine for about 3 weeks. This includes adapting to schema changes and table additions. However, last night a table was dropped and now it is failing since it cant fine the table. What is the best way to remove it from the state tracking so it does not try to find it, since we know it existed before, but will not in the future?

Two thoughts: 1. I wonder if it's looking for the table because of the cached catalog... try removing .meltano/run/tap-postgres/tap.properties.cache_key 2. If state really is the problem check out the

meltano state

commands. Basically you'll want to do

state get > file.json

to get the state state, edit file.json to remove the info about the dropped table, then run

state set

to load the modified state data into the meltano DB.

thank you...it was the chache_key. Removing that fixed the issues.

good good

https://github.com/meltano/meltano/issues/6763 could you upvote this? 😄