Hi All, _Im new to using Elementary with BigQuery...
# community-support
a
Hi All, _Im new to using Elementary with BigQuery pipelines. I've started by testing the
elementary.volume_anomalies
feature, but I'm not seeing any results being reported._ YAML:
Copy code
- name: final_table
    config:
      tags: ['final']
      schema: final_prod
      materialized: table
      elementary:
        timestamp_column: "pemoade_bq_dp_ts"
        config:
          severity: warn
        time_bucket:
          period: day
          count: 1
 
    tests:
      - elementary.volume_anomalies
order of execution : dbt run --select elementary -profiles-dir --project-dir dbt run --profiles-dir --project-dir --select final_table dbt test --profiles-dir --project-dir --select final_table edr report --profiles-dir --project-dir tests: - elementary.volume_anomalies: timestamp_column: pemoade_bq_dp_ts Its failing if I include timestamp_column: pemoade_bq_dp_ts in the tests Can someone please help me on this. Thanks
n
Hey Arjun! Seems like a syntax issue. Please try removing the "" over the column name, and set it up in this order:
Copy code
models:
  - name: < model name >
    tests:
      - elementary.volume_anomalies:
          timestamp_column: < timestamp column >
          time_bucket: # Daily by default
            period: < time period >
            count: < number of periods >
Let me know if this helps 🙂