All stacks · Operational data stores
Search, logs, and OpenSearch as a serving plane beside the warehouse.
Elasticsearch🟢BeginnerDynamic mapping stored amount as text, a terms agg became the executive number, and nobody could replay the index. Idempotent ids, a reindex fallback, and leave warehouse math in the warehouse.
Elasticsearch and OpenSearch are the search and log serving plane: inverted indexes, not a warehouse. Data engineers land events here for product search and observability, then regret using it as the system of record.
No. Different storage, different consistency, terrible at wide analytical joins. Search belongs in search. Finance belongs in a warehouse.
CDC or an event bus into the indexer, with an idempotent document id. Nightly full reindex is a fallback, not the architecture.
Whatever your cloud and license already are. AWS shops often land on OpenSearch. The DE skill is mappings and sync, not the brand fight.
