Hi How do you save and read dollar signs in a secret I m on

Question

Hi How do you save and read dollar signs in a secret I m on Prefect Server implemented in GCP The secret comes from Google Secret Manager I have a custom secret function that in development pulls the secret from my PC s environment variables I develop on Windows I now have a DB with a password containing dollar signs Because of <https github com PrefectHQ prefect blob ad734292bc4113a52777d6ebe87cfa1c13a3eee8 src prefect configuration py L83|this line> I can t read the password out correctly Thoughts Example ```import os from prefect client import Secret secret name = JSON SECRET os environ f PREFECT CONTEXT SECRETS secret name = db1 password password user userA db2 password P $$w0rd user userB secret value = Secret secret name get print secret value db2 password This prints P $w0rd not P $$w0rd ```

Stéphan Taljaard · Answer

I have another function that then takes the username and password and creates a SQLAlchemy connection string ```def create conn str username str password str host str database str port=None dialect= mssql driver= pymssql gt str Create a SQLAlchemy database URL connection string username = quote plus username password = quote plus password port = f port if port else return f dialect + driver username password host port database ``` Is my best option to save the value in the secret already url encoded i e ` P 40 24 24w0rd ` and then edit my `create conn str` to not double encode a string

Kevin Kho · Answer

Yikes that does seem like a pain First time I ve bumped into it I think your suggestion with already saving it as URL encoded is the best I can think of for now

Stéphan Taljaard · Answer

Yeah same Feels almost strange that this only came out now It was actually someone else in my team discovering it He first thought he s saving it wrong inside Windows env vars Debugged for him and voila

Kevin Kho · Answer

I don t know though if we can have both dollar signs and the interpolation though Feel free to open an issue