Ok so I accidentally* truncated a table in Snowfla...
# troubleshootingt
tj_murphy
02/01/2022, 1:21 AMOk so I accidentally* truncated a table in Snowflake loaded by Meltano. How do I tell Meltano to reload it from the beginning instead of from what it thinks is the most recent bookmark? It's in an extractor that has other tables as well, I'm hoping to just refresh this one table.
a
aaronsteers
02/01/2022, 1:37 AMThis is common enough that I have created a StackOverflow question and provided a quick answer as reply to my question: How can I manually edit STATE tracking in Meltano? - Stack Overflow
aaronsteers
02/01/2022, 1:38 AMThere are two options as of now:
1. Dump and re-import state. Export the state with theoption in--dumpand then reimport usingmeltano elt--state
2. Update the corresponding row within the Meltano system DB. Looking up the job's row in the Meltano system DB, manually edit the row within the database.
aaronsteers
02/01/2022, 1:39 AMDoes one of these 2 approaches appeal to you? If it would be helpful, I'm happy to expand whichever you think would be your preferred direction.
t
tj_murphy
02/01/2022, 2:14 AMThanks! I took approach #2. Scary but it did the trick.
a
aaronsteers
02/01/2022, 2:19 AMAwesome! Thanks! Glad it worked. 👍
t
taylor
02/01/2022, 3:05 PM@tj_murphy definitely give https://gitlab.com/meltano/meltano/-/issues/2754 a 👍 as it would hopefully solve your problem in the future 🙂