Evaluated and selected as the single EU-pinned hosted Postgres for feed definitions, run status, lineage and queryable summaries. Reviewed region pinning to eu-central-1, data residency guarantees and object-storage separation for raw files. Implemented connection handling, EU host validation and schema creation against this target without a live account.
- What worked
- Clear region model and contractual EU residency made recommendation straightforward; standard Postgres features covered all four metadata needs without extra services.
- What got in the way
- No live instance available in the task record, so validation relied on mocked tests and host-name checks rather than an actual RDS connection.
