# '$' character in database password throws error

**URL:** <https://discourse.greatexpectations.io/t/character-in-database-password-throws-error/412>\
**Category:** Archive\
**Created:** [September 23, 2020, 8:28pm UTC](https://discourse.greatexpectations.io/t/character-in-database-password-throws-error/412 "2020-09-23T20:28:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lrbsantos](https://avatars.discourse-cdn.com/v4/letter/l/aeb1de/32.png) [@lrbsantos](https://discourse.greatexpectations.io/u/lrbsantos)\
**Post date:** [September 23, 2020, 8:28pm UTC](https://discourse.greatexpectations.io/t/character-in-database-password-throws-error/412/1 "2020-09-23T20:28:11Z")

</div>

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](https://great-expectations.readthedocs.io/en/latest/reference/data_context_reference.html#managing-environment-and-secrets)”

---

<div class="post-metadata">

**Author:** ![bhcastleton](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/bhcastleton/32/73_2.png) [@bhcastleton](https://discourse.greatexpectations.io/u/bhcastleton)\
**Post date:** [September 23, 2020, 10:50pm UTC](https://discourse.greatexpectations.io/t/character-in-database-password-throws-error/412/2 "2020-09-23T22:50:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![eugene.mandel](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/eugene.mandel/32/22_2.png) [@eugene.mandel](https://discourse.greatexpectations.io/u/eugene.mandel)\
**Post date:** [September 25, 2020, 11:14pm UTC](https://discourse.greatexpectations.io/t/character-in-database-password-throws-error/412/3 "2020-09-25T23:14:39Z")

</div>

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](https://github.com/great-expectations/great_expectations/issues/1927)

Please subscribe to this issue to monitor its progress.

---

<div class="post-metadata">

**Author:** ![lrbsantos](https://avatars.discourse-cdn.com/v4/letter/l/aeb1de/32.png) [@lrbsantos](https://discourse.greatexpectations.io/u/lrbsantos)\
**Post date:** [September 25, 2020, 11:42pm UTC](https://discourse.greatexpectations.io/t/character-in-database-password-throws-error/412/4 "2020-09-25T23:42:29Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![eugene.mandel](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/eugene.mandel/32/22_2.png) [@eugene.mandel](https://discourse.greatexpectations.io/u/eugene.mandel)\
**Post date:** [November 13, 2020, 1:34pm UTC](https://discourse.greatexpectations.io/t/character-in-database-password-throws-error/412/5 "2020-11-13T13:34:05Z")

</div>

This issue is fixed.