uniqueness constraint on fact_claims is broken
Open
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

### 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
Assessment
This issue has not been assessed yet.