# Credential substitution variable not working for dynamically load evaluation parameters from a database

**URL:** https://discourse.greatexpectations.io/t/credential-substitution-variable-not-working-for-dynamically-load-evaluation-parameters-from-a-database/1076
**Category:** Archive
**Created:** [July 8, 2022, 6:09pm UTC](https://discourse.greatexpectations.io/t/credential-substitution-variable-not-working-for-dynamically-load-evaluation-parameters-from-a-database/1076 "2022-07-08T18:09:21Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![fullysane](https://avatars.discourse-cdn.com/v4/letter/f/c4cdca/32.png) [@fullysane](https://discourse.greatexpectations.io/u/fullysane)
#### Post date: [July 8, 2022, 6:09pm UTC](https://discourse.greatexpectations.io/t/credential-substitution-variable-not-working-for-dynamically-load-evaluation-parameters-from-a-database/1076/1 "2022-07-08T18:09:22Z")

</div>

I followed the guide on How to dynamically load evaluation parameters from a database at [How to dynamically load evaluation parameters from a database | Great Expectations](https://docs.greatexpectations.io/docs/guides/expectations/advanced/how_to_dynamically_load_evaluation_parameters_from_a_database/).  
I set up my\_query\_store in my great\_expectations.yml file’s store section as below:  
my\_query\_store:  
class\_name: SqlAlchemyQueryStore  
credentials: ${my\_mssql\_creds}  
queries:  
business\_unit\_code:  
query: “SELECT CD\_ID FROM dbo.SNGL\_CD WHERE TBL\_NBR\_ID = 108;”  
return\_type: “scalar” # return\_type can be either “scalar” or “list” or omitted  
governing\_state\_cd:  
query: “SELECT CD\_ID FROM dbo.SNGL\_CD WHERE TBL\_NBR\_ID = 573;”  
return\_type: “scalar” # return\_type can be either “scalar” or “list” or omitted

And I have in my config\_variables.yml the following codes:  
instance\_id: 0c93e5ff-a3b6-4da9-beec-db6414c0eb69

my\_mssql\_db:  
drivername: SQL Server Native Client 11.0  
host: [BI45526-DV.prodlb.travp.net](http://BI45526-DV.prodlb.travp.net)  
port: ‘45526’  
username: SaneData  
password: 2IZX4uxsaj  
database: db\_fusane

But I got the following error message when I run great\_expectations.

Unable to find a match for config substitution variable: `my_mssql_creds`.  
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)

the substitution variable: `my_mssql_creds` is there in my uncommitted/config\_variables.yml file. why do I get this error?

Please help!