Monitor the Rollout with BigQuery
- Application data was periodically synced to BigQuery
- We queried that copy to monitor the file path rollout
SELECT id, tenant_id, avatar, avatar_object_path
FROM app_mirror.employee_profiles
WHERE
(COALESCE(avatar, '') = '') != (avatar_object_path IS NULL)
OR NOT ENDS_WITH(avatar_object_path, CONCAT('/', avatar))
NOTE: Simplified from the actual code.
3. FOCUS ON FILE PATHS