I'm getting MetricProviderError: No provider found for column_pair_values.diff_custom_percentage.unexpected_count using SqlAlchemyExecutionEngine error when trying to create a custom expectation with SqlAlchemy functionality

Archive
1

Hi there,

I’ve been trying to build a custom expectation, with SqlAlchemy functionality. I’m currently running into an error when I run this cell:

validator.expect_column_pair_values_to_have_difference_of_custom_percentage(column_A=“ticket_id”, column_B=“numberry”, percentage=0.2, mostly=0.8)

the error I’m getting is this:

MetricProviderError: No provider found for column_pair_values.diff_custom_percentage.unexpected_count using SqlAlchemyExecutionEngine

I’m just wondering if someone could help me locate why I might be running into this error. I’ve been unable to figure it out.

Thanks in advance for any advice,
Dan