{
  "id": "e6148b49-1d82-4252-bc49-cdcf76bb7b35.test.dbt.dbt_expectations_expect_column_values_to_be_within_n_moving_stdevs_dq_overview_reporting_cube_daily_search_faq_click_rate__period_start_date__shared_condition_id__7__3_25__2__90.36420c8436",
  "alert_class_id": "test.dbt.dbt_expectations_expect_column_values_to_be_within_n_moving_stdevs_dq_overview_reporting_cube_daily_search_faq_click_rate__period_start_date__shared_condition_id__7__3_25__2__90.36420c8436.search_faq_click_rate.expectation",
  "model_unique_id": "model.dbt.dq_overview_reporting_cube_daily",
  "detected_at": "2024-02-22 05:07:27",
  "database_name": "redacted",
  "schema_name": "dbt",
  "owners": [
    "@renee.cooper"
  ],
  "tags": [
    "anomaly",
    "prod"
  ],
  "subscribers": [],
  "status": "fail",
  "suppression_interval": 0,
  "test_unique_id": "test.dbt.dbt_expectations_expect_column_values_to_be_within_n_moving_stdevs_dq_overview_reporting_cube_daily_search_faq_click_rate__period_start_date__shared_condition_id__7__3_25__2__90.36420c8436",
  "elementary_unique_id": "test.dbt.dbt_expectations_expect_column_values_to_be_within_n_moving_stdevs_dq_overview_reporting_cube_daily_search_faq_click_rate__period_start_date__shared_condition_id__7__3_25__2__90.36420c8436.search_faq_click_rate.expectation",
  "test_name": "dbt_expectations_expect_column_values_to_be_within_n_moving_stdevs_dq_overview_reporting_cube_daily_search_faq_click_rate__period_start_date__shared_condition_id__7__3_25__2__90",
  "test_display_name": "Dbt Expectations Expect Column Values To Be Within N Moving Stdevs Dq Overview Reporting Cube Daily Search Faq Click Rate  Period Start Date  Shared Condition Id  7  3 25  2  90",
  "severity": "ERROR",
  "table_name": "dq_overview_reporting_cube_daily",
  "table_full_name": "redacted.dbt.dq_overview_reporting_cube_daily",
  "test_type": "dbt_test",
  "test_sub_type": "expectation",
  "test_sub_type_display_name": "Expectation",
  "test_results_description": "Got 1 result, configured to fail if != 0",
  "test_results_query": "with metric_values as (\n\n    with grouped_metric_values as (\n\n        select\n            timestamp_trunc(\n        cast(period_start_date as timestamp),\n        day\n    ) as metric_period,\n            shared_condition_id,\n            sum(search_faq_click_rate) as agg_metric_value\n        from\n            `redacted`.`dbt`.`dq_overview_reporting_cube_daily`\n        group by 1,2\n\n    )\n    , grouped_metric_values_with_priors as (\n\n        select\n            *,\n            lag(agg_metric_value, 7) over(\n                partition by shared_condition_id\n                order by metric_per...