https://prefect.io logo
Title
a

Abhishek Mitra

05/11/2023, 5:29 AM
Hi all! Is there a way to avoid hardcoding the db credentials for
SQLAlchemyConnector
block and fetch it directly from AWS Secrets?
b

Bianca Hoch

05/11/2023, 6:20 PM
Hey Abhishek! I'd recommend checking out the AWS Secrets block to leverage using the AWS Secrets Manager in your flows.
a

Abhishek Mitra

05/12/2023, 4:44 AM
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?