limit

▶Changelog

Limit the number of failures that will be returned by a test query. We recommend using this config when working with large datasets and storing failures in the database.

• Specific test
• One-off test
• Generic test block
• Project level

Configure a specific instance of a generic (schema) test:

models/<filename>.yml

version: 2

models:
  - name: large_table
    columns:
      - name: very_unreliable_column
        tests:
          - accepted_values:
              values: ["a", "b", "c"]
              config:
                limit: 1000  # will only include the first 1000 failures