How to dynamically load evaluation parameters from a database

This article is for comments to: https://docs.greatexpectations.io/en/latest/how_to_guides/creating_and_editing_expectations/how_to_dynamically_load_evaluation_parameters_from_a_database.html

Please comment +1 if this How to is important to you.

If you prefer to load evaluation parameters from json, you can set up your expectation suite kwargs like:

        "kwargs": {
        "column": "yourcol",
        "min_value":{
            "$PARAMETER": "fu"
        },
        "max_value":{
            "$PARAMETER": "bar"
        }
    }

And then pass in a dictionary with {“fu”: 1, “bar”: 5} to the evaluation_parameters arg of validate.

Thanks!

To make this complete, in order to set defaults, add a evaluation_parameters key to the expectation suite JSON:

{
  "expectations": [],
  "data_asset_type": "Dataset",
  "evaluation_parameters": {
    "upstream_row_count": 10
  },
  "expectation_suite_name": "default",
  "meta": {
    "great_expectations_version": "0.13.19"
  }
}