How to manually edit STATE tracking in Meltano?

Question

There are several scenarios where we it would be useful to manually edit job state in Meltano. For example, if a table is accidentally deleted in the target SQL warehouse, the user may want to remove the incremental bookmark for just that table while not fully deleting the state entry for the entire job ID.

What's the best way to alter that STATE record?

Answer 1

There are two options as of now:

1. Dump and re-import state. Export the state with the --dump option in meltano elt, manually edit the STATE json, and then reimport using --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.