Hi I created an aws aurora cluster inside a vpc, I have a script that I am running using pulumi remote command, which is running a sql script against the previously created instance. The remote command depends on a different resource, which inturn depends on the aurora cluster. However the script are still getting executed before the clusters in the instance are fully provisioned and I get an error back that the host is unknown, how can I prevent this?

Have you tried putting all of the code inside a custom component resource and linking the dependencies? I think pulumi builds a dependency DAG automatically if you use outputs from other resources when creating others