Operations 26w35

monkey-id
Operations 26w35

This session is for operational work during this week. Address (monkey-task-context) items directly, one subheading in the NOTE is for one item.

Fix mapping-pipeline deployment due to SSM parameter

https://github.com/FindHotel/mapping-pipeline/actions/runs/32779045038/job/97599196109

Fix Dependabot failure in content-pipeline

https://github.com/FindHotel/content-pipeline/actions/runs/32709801786/job/97378566903

Fix content-pipeline deployment due to SSM parameter

Same as above for mapping-pipeline.

This parameter should not be used, part of Migrate Content system to Keypair auth in Snowflake. Check that it is not in use and remove the whole parameter.

Remove pagerduty SSM parameters from mapping-pipeline
wt
(◊git-status "~/.wt/mapping-pipeline_remove-pagerduty-parameters")
PR
Remove unused SSM parameters ⋅ mapping-pipeline#2070
AWS_PROFILE=fh-meta AWS_REGION=eu-west-1 \
aws ssm describe-parameters --page-size 50 | gron | grep Name | grep sovitin | grep pagerduty
Remove cms-update-hotel

With migration to OPUS, (◊grep 'content-pipeline "cms-update-hotel") is probably no longer needed - it calls Hotel API for hotel content.

Check in the ~/.vio/OPUS repository.

If confirmed, cleanup content-pipeline and mapping-pipeline repos.

PR has been merged, deploy on staging envornment, and monitor production deployment.

CONTENT-4186 Fix img-proxy source image fetch timeoutsCase
related
ImgProxy

Redeployed obfuscated-proxy v1.4.0, check if that fixed. No.

CONTENT-2793 agd_duplicated_hotel_feedback expiredCase PR

The PR mapping-pipeline#1981 was closed due to stalliness. Need to address comments and merge it.

CONTENT-2793 - mapping-prod, AGD feedback CSV

  • Root cause (10th confirmation): bucket-wide 180-day S3 lifecycle rule expired agd_duplicated_hotel_feedback/latest.csv. Mitigated 2026-06-10; last 12 runs SUCCEEDED.
  • Still open: lifecycle rule unscoped, loader unhardened. Hard deadline 2026-12-07 — file expires again.
  • Recommend: close as mitigated, stop recurring re-checks, file follow-up before deadline. Owner ping to hguo@vio.com unanswered since 06-15.
Remove ECS infrastructure from obfuscated-proxy

Obfuscated Proxy was migrated to EKS, old ECS IaC is not relevant. Cleanup.

Monitor if upgrade to Spark 4 works
Cleanup usage of content.interface.placeStory 
use role content_dbt_prod;
use schema content.content_prod;
alter table content.content_prod.place rename to place_hco;
create view content.content_prod.place as select * from content.content_prod.place_spark;

Content Squad announcement:

  • Old content.content_prod.place table (HCO-based) has been renamed and considered private
  • content.content_prod.place now a view over production-ready table developed within PI: Better Geographic UX | Notion.