Hmm, I have only ever worked in data warehouses that don't support updates - I think that is a core attribute of a DW. Warehouses are (IME) considered separate

Hmm, I have only ever worked in data warehouses that don't support updates - I think that is a core attribute of a DW. Warehouses are (IME) considered separate from production, with one major difference being that DWs don't need to support updates or transactions. Deletes are possible in Clickhouse[0] [0] - https://clickhouse.com/docs/en/sql-reference/statements/alter/delete/ https://clickhouse.com/docs/en/sql-reference/statements/alte...