great_expectations icon indicating copy to clipboard operation
great_expectations copied to clipboard

Result JSON: SQL without RWI list

Open lenok2018 opened this issue 5 months ago • 5 comments

Hello team. Our team faces an unpleasant experience, using "expect_column_values_to_not_be_null" check with Prod data. Prod DB tables contain a lot of null values now, so running GE test suits we obtain result JSON with thousands RWI in section Result format--> unexpected_list with COMPLETE setting. We know that its an expected behavior of Complete setting, but this affects out result json significantly. So, we are asking for new feature to provide the SQL without all this unexpected list rows. Maybe it could be an additional Keyword argument, which can switch off Unexpected list specification or some other decision.

Please, review the example of our json file - there are more than 40000 RWI in unexpected list:

image

lenok2018 avatar Mar 08 '24 11:03 lenok2018

Hey @lenok2018 ! Thanks for raising this feature request -- we've captured this feedback for our internal backlog. I've leave this issue open for the next week if you have any additional context you'd like to provide. 🙇

austiezr avatar Mar 18 '24 17:03 austiezr