fivetran / fivetran/dbt_google_play
[Bug] Test fail upon erroneous Google Play data
- Dominant language
- No language data
- Stars
- 2
- Forks
- 3
- PR merge metrics
- No merged PRs in 30d
Description
### Is there an existing issue for this?
- [X] I have searched the existing issues
### Describe the issue
Recently, we noticed that some of our Google Play data contained errors at the source and the tests from the package are failing as a result.
Specifically, for the month of February, our source data contains two sets of ratings for the country of Curacao (CW). This causes the error below in our dbt pipelines.
### Relevant error log or model output
```shell
08:20:55 Failure in test dbt_utils_unique_combination_of_columns_stg_google_play__stats_ratings_country_package_name__date_day__country (models/stg_google_play.yml)
08:20:55 Got 28 results, configured to fail if != 0
```
### Expected behavior
If not unreasonable, I would expect the test to run on some base model in which the possibility of duplicate records has been addressed.
### dbt Project configurations
N/A
### Package versions
```
- package: fivetran/google_play # https://github.com/fivetran/dbt_google_play
version: 0.2.0
- package: fivetran/google_play_source # https://github.com/fivetran/dbt_google_play_source
version: 0.2.0
```
### What database are you using dbt with?
snowflake
### dbt Version
1.4
### Additional Context
_No response_
### Are you willing to open a PR to help address this issue?
- [ ] Yes.
- [ ] Yes, but I will need assistance and will schedule time during our [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance
- [X] No.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.