Is there a way to check if a resource exists before proceeding with a code snippet ? like say for example if I've ran a script that creates a 3 tier arch, 1 DB and a secrets manager, I now have to add a change and run the script , if the resource exists then I want to omit updating the secrets obj as that contains current DB password

you shouldn’t really be doing this. Pulumi is a desired state tool, in that if it’s defined in the pulumi code it’ll be created. What you’re describing is an imperative action, whereas Pulumi is declarative