I’m new to GX and trying to get my head around everything. Looking at the [expect_column_min_to_be_between](https://greatexpectations.io/expectations/expect_column_min_to_be_between), I’m just not groking why I would set a minimum and maximum value for what the minimum value of a column should be. I…

Sure! Stock market data is a good example of this. Suppose we are using intraday stock market data for CAT. Picking one source, the alphavantage api, we’d get multiple datapoints for each day, depending on the interval we selected. To ensure that all of the data are reasonable, I might set an expec…

You’re right that if you know the exact range of values that a column will have then you would know the exact minimum. But, if there is variation between different batches of data, then it may make more sense to expect the minimum of any given batch to fall in a range. For example, you might expect …

Ah! Thank you. The parameterization example really makes the need for that clear.

Why would a minimum value be defined in a range?

GX Core Support

Barrett July 19, 2023, 8:08pm 3

I appreciate you responding, @jpcampbell42. I’m afraid I’m still not seeing it though. Can you give a real world example of when a range for the minimum would be appropriate?

Topic		Replies	Views
How to set expectation to have a threshold GX Core Support how-to	5	354	October 18, 2024
How could I create an expectation to say the time value in a field should be later than some number of hours ago? Archive types-of-expectation	0	558	September 29, 2020
Expect_column_value_lengths_to_be_between: ERROR SQLSTATE 42704 GX Core Support databricks	1	295	May 6, 2024
Evaluate evaluation parameters for data docs Archive	1	541	October 26, 2020
Can we combine/chain expectations or use expectations with specific rules depending on values of another column? Archive how-to	0	546	May 18, 2021

Why would a minimum value be defined in a range?

Related topics