Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hi all! Is there a way to avoid hardcoding the db credentials for `SQLAlchemyConnector`  block and fetch it directly from AWS Secrets?

Hey Abhishek! I'd recommend checking out the <https://prefecthq.github.io/prefect-aws/secrets_manager/#prefect_aws.secrets_manager.AwsSecret|AWS Secrets block> to leverage using the <https://prefecthq.github.io/prefect-aws/#using-prefect-with-aws-secrets-manager|AWS Secrets Manager> in your flows.

Hi Bianca! Thanks for the resources I  saw that. But even if we create a sql connector  block through python script wont the secrets value be harcoded for the block? Is there a way to dynamically fetch aws secret value  and configure it for the sqlalchemy connector block everytime when its loaded or the secret value is rotated?