# Available checks


The following table lists references for all available conditions that can be used in your rules. Note that aggregated conditions cannot be combined with non-aggregated conditions in the same rule. 

**Note**  
For SDK users, to apply the same rule to multiple columns use the [ColumnSelectors](https://docs.aws.amazon.com/databrew/latest/dg/API_ColumnSelector.html) attribute of a [Rule](https://docs.aws.amazon.com/databrew/latest/dg/API_Rule.html) and specify validated columns using either their names or a regular expression. In this case, you should use implicit *CheckExpression*. For example, `“> :val”` to compare values in each of the selected columns with the provided value. DataBrew uses implicit syntax for defining [FilterExpression](https://docs.aws.amazon.com/databrew/latest/dg/API_FilterExpression.html) in dynamic datasets. If you want to specify column(s) for each check individually, don't set the *ColumnSelectors* attribute. Instead, provide an explicit expression. For example, `“:col > :val”` as a *CheckExpression* in a *Rule*.


****  
[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/databrew/latest/dg/profile.data-quality-available-checks.html)

**Numeric comparisons**

DataBrew supports the following operations for numeric comparison: *Is equals (==)*, *Is not equals (\$1=)*, *Less than (<)*, *Less than equals (<=)*, *Greater than (>)*, *Greater than equals (>=)* and *Is between (is\$1between :val1 and :val2)*.

**String comparisons**

The following string comparisons are supported: *Starts with*, *Doesn’t start with*, *Ends with*, *Doesn’t end with*, *Contains*, *Doesn’t contain*, *Is equals*, *Is not equals*, *Matches*, *Doesn’t match*. 

The following table displays available statistics that you can use for Value distribution statistics and Numerical statistics:


****  
[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/databrew/latest/dg/profile.data-quality-available-checks.html)