Hi all! We are trying to create a set of standard ...
# community-support
d
Hi all! We are trying to create a set of standard elementary anomaly tests for our curated layer in dbt. We can easily add the following yaml to each model, but I would love to add it to the project file. I've heard that isn't possible? Is there a way to define the below tests once and reference them in each model property yaml? Here are the 3 tests we want to add to every model in a specific schema/folder:
Copy code
tests:
      - elementary.volume_anomalies:
          timestamp_column: bi_updated_datetime
      - elementary.freshness_anomalies:
          timestamp_column: bi_updated_datetime
          anomaly_direction: spike
      - elementary.all_columns_anomalies:
          timestamp_column: bi_updated_datetime  
          anomaly_direction: spike
          column_anomalies:
            - null_percent