fivetran / fivetran/dbt_google_play

[Bug] Test fail upon erroneous Google Play data

Open
#8 10 comments 0 reactions 0 assignees View on GitHub
status:scoping type:wontfix
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.