Re:Databricks response to Snowflake's accusation of lacking ...
by doppelganger1 on Thursday November 18, 2021 @12:45PM
(#29268242)
Actually, you would expect that in an OLTP world. DW's for the longest time, even Oracle, recommends you disable txn to get better performance. The logic is implemented in the ETL layer. Very rarely do you need multi-table txn in large scale DW.
Snowpark is still inferior.
Snowflake now offers Scala, Java and Python support, so it would seem their capabilities are converging even more, but both with their own strengths due to their respective histories.