-werners-
Esteemed Contributor III

I would not use it as an OLTP system. The reason why is simple:

lakehouse is heavily dependent on 'big data file formats' like parquet, delta lake, orc, iceberg etc.

These are typically immutable.

In an oltp system you have to do a lot of small synchrone updates which is cumbersome in a lakehouse (because of the immutability of the files).

I don't see the added value (compared to an RDBMS) using a lakehouse for OLTP.

For OLAP workloads: totally.