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.
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
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
the substitution variable: my_mssql_creds
is there in my uncommitted/config_variables.yml file. why do I get this error?
Please help!