dbt-labs / dbt-labs/dbt-utils

uniqueness constraint on fact_claims is broken

Open
#999 0 comments 0 reactions 0 assignees View on GitHub
bug triage
Dominant language
Makefile
Stars
1.8k
Forks
632
PR merge metrics
No merged PRs in 30d

Description

### Describe the bug

select *
from marts.claims.fact_claims
where pk_sam_claim_own_gross_reported = 5508714

We expect 1 row, we get 2

### Steps to reproduce

Run the query

### Expected results

1 row

### Actual results

2 rows

### Screenshots and log output

![Image](https://github.com/user-attachments/assets/cf102530-f502-4cef-99fe-ec64d9228fe0)

### System information
**The contents of your `packages.yml` file:**

**Which database are you using dbt with?**
- [ ] postgres
- [ ] redshift
- [ ] bigquery
- [ ] snowflake
- [ ] other (specify: ____________)

**The output of `dbt --version`:**
```

```

### Additional context

### Are you interested in contributing the fix?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.