Hi, I'm using self hosted prefect and I want to configure my own PostgresDB. What's the best way to pass in the connection string? I don't want to store the password in a plaintext environment variable. I'd prefer to resolve it at runtime from AWS Secrets Manager, if possible. Can anyone advice? Thanks.

how are you deploying the server?

I use AWS CDK to deploy the prefect server to ECS. I have an RDS Postgres instance deployed using the same CDK configuration.

we used environment files from S3 -> that's very far from perfect, but got it done