How to set up a conditional expectations for Snowflake with Great Expectations?

Question

I'm trying to set up a Conditional Expectation with Great Expectations for a Snowflake table that's in a long format.

For this tests, consider a table with two columns, measurement_type and value. I want to check that the value is between 0 and 360 if the measurement_type is 'wdir'.

validator.expect_column_unique_value_count_to_be_between(
    column='value', 
    max_value=0, 
    min_value=360, 
    condition_parser='sql',
    row_condition='measurement_type=="wdir"',
    strict_max=False, 
    strict_min=False, 
    meta={'profiler_details': {'metric_configuration': {'domain_kwargs': {'column': 'project'}, 'metric_name': 'column.distinct_values.count', 'metric_value_kwargs': None}, 'num_batches': 1}})

This is returning:

GreatExpectationsError: SqlAlchemyExecutionEngine only supports the great_expectations condition_parser.