Ok so I figured out how to access credentials. For anyone looking in the future you can go to the secrets manager, there will be a secret there for your rds instance, grab the ARN and you can connect in via the query editor in rds dashboard 👌

I am still unsure about why my migrations didn't apply correctly and will continue to investigate unless anyone else has an idea 👍

I have been doing some digging and it seems like to run the migration scripts, you guys make a copy of the migration file in the directory

var/task/sst_rds_migration_scripts/

i did a bit of googling and it seems you can only create files in the

tmp/

directory of a lambda, and if you try to use another folder you might see the sort of error mentioned above. Wondering if you think this could be the cause of the issue at all @thdxr or @Frank Also curious if you guys have successfully ran migrations for an RDS instance on deploy before? It might just be me but not sure here. I did make sure my IAM role is setup properly too so I don't think it is a permissions error.

Also saw this in docs not sure if it is an old typo or if i need to configure something to enable running migrations?

Actually also unsure if unrelated but after update locally running sst yields this. Deploy seemed to work find though...

yea just to confirm I don't seem to be able to download the latest versions of sst since it breaks with the above message, could potentially be a windows thing but not 100% sure

Let me know if both the deploy issue and the migrations issue are fixed.

Hey @Frank so I have upgraded, i no longer get the issue mentioned before where i couldn't run sst, however the migrations did not get applied 🤔 I have tried manually deploying again as well as general code changes. Is there something I have to do to trigger the migrations?

I can also see the migration function and migration handler lambdas have not been run for a while as well

If not, could you make a dummy change to one of your migration files (or add a new dummy migration), and trigger a deploy again?

If migration does not get run, DM me the link to the build on Seed, I will take a look.

Thanks for the advice 🙏