bc3a364891
# Description * Adds the new snapshot for Guesty Claims, up to 1st July 2025. * Creates a model named int_athena__high_risk_client_detector that handles the following logic: 1. The User has been using the agreed services for at least (3) months 2. The aggregated number of claims filed by the User exceeds a total of £2300 3. The User has filed at least (5) claims 4. The User has a claim ration of (7%) or higher throughout their entire use of agreed services, including any claim that has received a guarantee payment It's heavily opinionated due to lack of clear requirements and lack of data quality, both in athena verifications and guesty claims. Please, check the inline comments for more info. With these model and conditions, only 2 users would be tagged as high risk. # Checklist - [X] The edited models and dependants run properly with production data. - [X] The edited models are sufficiently documented. - [X] The edited models contain PK tests, and I've ran and passed them. - [X] I have checked for DRY opportunities with other models and docs. - [X] I've picked the right materialization for the affected models. # Other - [ ] Check if a full-refresh is required after this PR is merged. Related work items: #31687 |
||
|---|---|---|
| .. | ||
| .gitkeep | ||
| schema.yml | ||
| stg_seed__accounting_aggregations.csv | ||
| stg_seed__athena_price_history.csv | ||
| stg_seed__currencies.csv | ||
| stg_seed__guest_services_vat_rates_by_country.csv | ||
| stg_seed__guesty_resolutions_snapshot_20250701.csv | ||
| stg_seed__hubspot_account_owner.csv | ||
| stg_seed__main_metrics_targets.csv | ||
| stg_seed_guesty_claims_snapshot_20241010.csv | ||