Hello! Error raised when in table elementary.alerts_v2 in column

data

materialization is Null and some other columns is empty. How to reproduce: 1. edr test 2. edr monitor. Enviroment: Clickhouse

edr (0.23.1) and Elementary's dbt package (0.23.0) are compatible.

{
  "id": "ba573cab-5eee-472d-bbf4-065288078911.model.analytics.fct_activation_flow_monetization",
  "model_unique_id": null,
  "alert_class_id": "model.analytics.fct_activation_flow_monetization",
  "alias": "fct_activation_flow_monetization",
  "path": "silver/fct/fct_activation_flow_monetization.sql",
  "original_path": "models/silver/fct/fct_activation_flow_monetization.sql",
  "materialization": null,
  "detected_at": "2026-04-02T15:44:54",
  "database_name": "",
  "schema_name": "silver",
  "full_refresh": null,
  "message": null,
  "owners": "[]",
  "tags": "[\"datamart\", \"product\"]",
  "model_meta": "{}",
  "status": "none",
  "job_id": "",
  "job_name": "",
  "job_run_id": "",
  "job_url": "",
  "job_run_url": "",
  "orchestrator": ""
}

[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO - 
[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO -     ________                          __
[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO -    / ____/ /__  ____ ___  ___  ____  / /_____ ________  __
[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO -   / __/ / / _ \/ __ `__ \/ _ \/ __ \/ __/ __ `/ ___/ / / /
[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO -  / /___/ /  __/ / / / / /  __/ / / / /_/ /_/ / /  / /_/ /
[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO - /_____/_/\___/_/ /_/ /_/\___/_/ /_/\__/\__,_/_/   \__, /
[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO -                                                  /____/
[2026-04-06, 05:10:12 UTC] {subprocess.py:106} INFO - 
[2026-04-06, 05:10:13 UTC] {subprocess.py:106} INFO - Any feedback and suggestions are welcomed! join our community here - <https://bit.ly/slack-elementary>
[2026-04-06, 05:10:13 UTC] {subprocess.py:106} INFO - 
[2026-04-06, 05:10:13 UTC] {subprocess.py:106} INFO - 2026-04-06 05:10:13 — INFO — Running with edr=0.23.1
[2026-04-06, 05:10:19 UTC] {subprocess.py:106} INFO - 2026-04-06 05:10:19 — INFO — edr (0.23.1) and Elementary's dbt package (0.23.0) are compatible.
[2026-04-06, 05:10:20 UTC] {subprocess.py:106} INFO - 2026-04-06 05:10:20 — INFO — Elementary's database and schema: 'elementary.elementary'
[2026-04-06, 05:10:20 UTC] {subprocess.py:106} INFO - 2026-04-06 05:10:20 — INFO — Running internal dbt run to populate alerts
[2026-04-06, 05:10:20 UTC] {subprocess.py:106} INFO - 2026-04-06 05:10:20 — INFO — Running dbt command --log-format json run -s elementary_cli.alerts.alerts_v2 --project-dir /home/***/.local/lib/python3.12/site-packages/elementary/monitor/dbt_project --profiles-dir /opt/***/dags/analytics --vars {"days_back": 1}
[2026-04-06, 05:10:35 UTC] {subprocess.py:106} INFO - 2026-04-06 05:10:35 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_pending_alerts", "macro_args": {"days_back": 1, "type": null}} --project-dir /home/***/.local/lib/python3.12/site-packages/elementary/monitor/dbt_project --profiles-dir /opt/***/dags/analytics
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO - Traceback (most recent call last):
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/bin/edr", line 6, in <module>
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     sys.exit(cli())
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -              ^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/click/core.py", line 1157, in __call__
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     return self.main(*args, **kwargs)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -            ^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/click/core.py", line 1078, in main
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     rv = self.invoke(ctx)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -          ^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/elementary/cli/cli.py", line 66, in invoke
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     return super().invoke(ctx)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -            ^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/click/core.py", line 1688, in invoke
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     return _process_result(sub_ctx.command.invoke(sub_ctx))
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/click/core.py", line 1666, in invoke
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     rv = super().invoke(ctx)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -          ^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/click/core.py", line 1434, in invoke
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     return ctx.invoke(self.callback, **ctx.params)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/click/core.py", line 783, in invoke
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     return __callback(*args, **kwargs)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/click/decorators.py", line 33, in new_func
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     return f(get_current_context(), *args, **kwargs)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/elementary/monitor/cli.py", line 413, in monitor
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     success = data_monitoring.run_alerts(
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -               ^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/elementary/monitor/data_monitoring/alerts/data_monitoring_alerts.py", line 449, in run_alerts
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     alerts = self._fetch_data(days_back)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -              ^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/elementary/monitor/data_monitoring/alerts/data_monitoring_alerts.py", line 166, in _fetch_data
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     return self.alerts_api.get_new_alerts(
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/elementary/monitor/api/alerts/alerts.py", line 28, in get_new_alerts
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     pending_alerts = self.alerts_fetcher.query_pending_alerts(days_back=days_back)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/elementary/monitor/fetchers/alerts/alerts.py", line 50, in query_pending_alerts
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     PendingAlertSchema(**result)
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   File "/home/***/.local/lib/python3.12/site-packages/pydantic/v1/main.py", line 341, in __init__
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -     raise validation_error
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO - pydantic.v1.error_wrappers.ValidationError: 1 validation error for PendingAlertSchema
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO - __root__ -> materialization
[2026-04-06, 05:10:45 UTC] {subprocess.py:106} INFO -   none is not an allowed value (type=type_error.none.not_allowed)
[2026-04-06, 05:10:46 UTC] {subprocess.py:110} INFO - Command exited with return code 1
[2026-04-06, 05:10:46 UTC] {taskinstance.py:3311} ERROR - Task failed with exception
Traceback (most recent call last):
  File "/home/airflow/.local/lib/python3.12/site-packages/airflow/models/taskinstance.py", line 767, in _execute_task
    result = _execute_callable(context=context, **execute_callable_kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/airflow/.local/lib/python3.12/site-packages/airflow/models/taskinstance.py", line 733, in _execute_callable
    return ExecutionCallableRunner(
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/airflow/.local/lib/python3.12/site-packages/airflow/utils/operator_helpers.py", line 252, in run
    return self.func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/airflow/.local/lib/python3.12/site-packages/airflow/models/baseoperator.py", line 417, in wrapper
    return func(self, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/airflow/.local/lib/python3.12/site-packages/airflow/operators/bash.py", line 276, in execute
    raise AirflowException(
airflow.exceptions.AirflowException: Bash command failed. The command returned a non-zero exit code 1.

@Noya Offer Can you create a ticket? I send message before but not have a response. Slack Message

Sure!

@Yosef Arbiv Thanks!