'$' character in database password throws error

Support
#1

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
#2

@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?

#3

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.

#4

Hi @bhcastleton and @eugene.mandel, thanks for your replies. I’ll will monitor the issue.