SQL query return rows

​
Definition

The SQL query return rows test allows you to write custom WHERE conditions to filter your data and set thresholds based on the number of rows that match your criteria. This test counts the rows that satisfy your specified conditions and compares the count against your defined thresholds. You write the filtering condition without the WHERE keyword - the system automatically applies it to your dataset as df.

​
Taxonomy

  • Task types: LLM, tabular classification, tabular regression, text classification.
  • Availability: and .

​
Why it matters

  • The SQL query return rows test provides a powerful way to validate data quality by counting rows that meet specific criteria.
  • You can easily identify data anomalies, outliers, or violations of business rules by setting thresholds on row counts.
  • This test is ideal for monitoring data consistency, detecting unusual patterns, or ensuring data meets expected distributions.
  • It simplifies the creation of data validation rules without requiring complex SQL knowledge - just specify the filtering conditions.