Let's say I have an RDS database who's sole job is...
# infra-deployments
Stéphane Burwash
06/01/2022, 12:40 PMLet's say I have an RDS database who's sole job is to provide state management persistent state management for my ECS container which hosts meltano. Any idea how to reset the state of ONLY 1 TAP (with restarting the entire DB) ?
v
visch
06/01/2022, 1:06 PMvisch
06/01/2022, 1:06 PMDoes this do / not do what you want?
s
Stéphane Burwash
06/01/2022, 1:07 PMHopefully. Now I need to learn enough from ECS to see if I can remotely connect to it
v
visch
06/01/2022, 1:07 PMs
Stéphane Burwash
06/01/2022, 1:07 PMWorst comes to worst, I can always push my code with a state clear in my docker file
v
visch
06/01/2022, 1:08 PMRDS database who's sole job is to provide state management persistent state managementand
Hopefully. Now I need to learn enough from ECS to see if I can remotely connect to it== yes
visch
06/01/2022, 1:08 PMThat will just work
visch
06/01/2022, 1:09 PMProbably worth spending some time understanding https://docs.meltano.com/contribute/prerequisites#system-database and how state is stored starting https://docs.meltano.com/reference/command-line-interface#state is a good start
visch
06/01/2022, 1:09 PMI like to just store state a few times in a local DB (or even the included sql lite db) and stare at the state in the DB
s
Stéphane Burwash
06/01/2022, 1:25 PMI understand state management. I'm not sure I understand the system database portion. Do you think this is something I could ask for clarification during office hours?
v
visch
06/01/2022, 1:25 PMyes, absolutely do it!