<@U088WCP3B4P> My dbt models table has multiple du...
# ask-elementary-ail
Luiz Felipe Campos da Silva
11/26/2025, 2:50 PM@kapa.ai My dbt models table has multiple duplicated rows with the same unique_id
140010 Database Error in model dbt_models (src/models/monitoring/artifacts/dbt_models.sql)
[DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE] Cannot perform Merge as multiple source rows matched and attempted to modify the same
target row in the Delta table in possibly conflicting ways. By SQL semantics of Merge,
when multiple source rows match on the same target row, the result may be ambiguous
as it is unclear which source row should be used to update or delete the matching
target row. You can preprocess the source table to eliminate the possibility of
multiple matches. Please refer to
https://docs.databricks.com/delta/merge.html#merge-error
k
kapa.ai
11/26/2025, 2:50 PMA message from kapa.ai
kapa.ai
11/26/2025, 2:50 PMThis error is caused by duplicate rows in Elementary’s
dbt_modelsunique_idgenerated_atedr monitoredr reportunique_iddbt_modelsdbt_testsdbt_sourcesDELTA_CONCURRENT_DELETE_READdbt_modelsdelete_and_insertdbt_models Copy code
sql create or replace table elementary.dbt_models as ( select * from elementary.dbt_models qualify row_number() over (partition by unique_id order by generated_at) = 1 );dbt_testsdbt_sourcesdbt_exposuresdbt_columnsdbt_modelsdbt run -s elementaryedr monitoredr monitor send-reportdisable_dbt_artifacts_autoupload = true Copy code
bash dbt run --select elementary.edr.dbt_artifactsdbt_modelsedr34 Views