# Syntax of Requested Metrics for Store Metrics Action in case of Column Pair Map Expectation

**URL:** <https://discourse.greatexpectations.io/t/syntax-of-requested-metrics-for-store-metrics-action-in-case-of-column-pair-map-expectation/1590>\
**Category:** GX Core Support\
**Tags:** how-to, help-wanted\
**Created:** [January 21, 2024, 8:51pm UTC](https://discourse.greatexpectations.io/t/syntax-of-requested-metrics-for-store-metrics-action-in-case-of-column-pair-map-expectation/1590 "2024-01-21T20:51:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhyzhkea](https://avatars.discourse-cdn.com/v4/letter/z/839c29/32.png) [@zhyzhkea](https://discourse.greatexpectations.io/u/zhyzhkea)\
**Post date:** [January 21, 2024, 8:51pm UTC](https://discourse.greatexpectations.io/t/syntax-of-requested-metrics-for-store-metrics-action-in-case-of-column-pair-map-expectation/1590/1 "2024-01-21T20:51:16Z")

</div>

Hi Team,

Please help me with an example or pointer to documentation to properly set requested metrics for “Column Pair Map Expectation” type like “expect\_column\_pair\_values\_to\_be\_equal”.

I was successful to set it up for “Column Map Expectation” like “expect\_column\_values\_to\_not\_be\_null”.

Documentation mentioned use of:

expectation\_suite\_name:  
metric\_name:  
- metric\_kwargs\_id

Where:  
metric\_kwargs\_id is a string representation of the Metric Kwargs that can be used as a database key.  
For simple cases, it could be easily readable, such as column=Age, but when there are multiple keys and values or complex values,  
it will most likely be an md5 hash of key/value pairs.

I can not find example how to create md5 hash of key/value pairs.

Here is part of my “action\_list” dictionary for checkpoint.

```
  {
    "name": "store_metrics",
    "action": {
      "class_name": "StoreMetricsAction",
      "target_store_name": "metric_store",
      "requested_metrics": {
        "TRANSACTION_FACT Referential Integrity Tests": [
          {
            "column": {
              "DW_SECURITY_ID": [
                "expect_column_values_to_not_be_null.result.element_count",
                "expect_column_values_to_not_be_null.result.unexpected_index_list",
                "expect_column_values_to_not_be_null.result.missing_count",
                "expect_column_values_to_not_be_null.result.missing_percent",
                "expect_column_values_to_not_be_null.result.unexpected_count",
                "expect_column_values_to_not_be_null.result.unexpected_percent",
                "expect_column_values_to_not_be_null.result.unexpected_percent_nonmissing",
                "expect_column_values_to_not_be_null.result.unexpected_list",
                "expect_column_values_to_not_be_null.result.unexpected_index_query"
              ]
            }
          },
          **{**

```

\*\* “column\_A,column\_B”: {\*\*  
\*\* “DW\_SECURITY\_ID,DIM\_SECURITY\_ID”: \*\*  
\*\* [\*\*  
\*\* “expect\_column\_pair\_values\_to\_be\_equal.table.row\_count”,\*\*  
\*\* "expect\_column\_pair\_values\_to\_be\_equal.column\_pair\_values.equal.filtered\_row\_count,\*\*  
\*\* “expect\_column\_pair\_values\_to\_be\_equal.column\_pair\_values.equal.unexpected\_count”,\*\*  
\*\* “expect\_column\_pair\_values\_to\_be\_equal.column\_pair\_values.equal.unexpected\_values”\*\*  
\*\* ]\*\*  
\*\* }\*\*  
},  
“statistics.successful\_expectations”,  
“statistics.evaluated\_expectations”,  
“statistics.success\_percent”,  
“statistics.unsuccessful\_expectations”  
]  
}  
}  
}

Any help is greatly appreciated. Thanks.