How do you handle data quality issues or missing values during a transformation process at Roblox?
Using the provided Roblox experience and raw event tables, write a query that validates event records, treats missing creator identifiers as unknown, excludes invalid visit counts from totals, and preserves experiences with no valid events.
experience_id, experience_name, valid_event_count, invalid_event_count, valid_visit_total, missing_creator_event_count, and quality_status.experience_id ascending, and label each status as ready, review, or no_valid_events.| Column | Type | Description |
|---|---|---|
| experience_idPK | INT | Roblox experience identifier |
| experience_name | VARCHAR(120) | Display name of the experience |
| Column | Type | Description |
|---|---|---|
| raw_event_idPK | INT | Raw event identifier |
| experience_id | INT | Referenced experience identifier, which can be missing or unmatched |
| event_type | VARCHAR(30) | Raw event type |
| event_ts | TIMESTAMP | Event timestamp |
| visit_count | INT | Visit count reported by the event |
| creator_id | VARCHAR(40) | Creator identifier, which may be null or blank |