Hi, I am trrying to connect to a Oracle database, the database user’s password has the ‘$’ character and seems GE is trying to “parse” the password and throwing error when trying to connect to the database. How can I escape the '$" character? The error message is below.
“Unable to find a match for config substitution variable: $xxxxx. Please add this missing variable to your uncommitted/config_variables.yml file or your environment variables. See https://great-expectations.readthedocs.io/en/latest/reference/data_context_reference.html#managing-environment-and-secrets”
1 Like
@lrbsantos Thanks for your question. Before answering your question, I just want to note that we don’t currently have full Oracle support. But hopefully it can still work similar to other major sqlalchemy data sources.
wrt your question: @eugene.mandel, can you provide some feedback on if there is a way to escape the special character in a config variable?
This is a bug - thank you for reporting it! I filed it as a Github issue: https://github.com/great-expectations/great_expectations/issues/1927
Please subscribe to this issue to monitor its progress.
Hi @bhcastleton and @eugene.mandel, thanks for your replies. I’ll will monitor the issue.