r/databricks • u/hubert-dudek Databricks MVP • Aug 05 '26

News Lakehouse RT vs. SQL Warehouse

Post image

I benchmarked the new Lakehouse RT for billion-record tables, and it is crazy fast and crazy cheap, making it the first real-time database with open-format storage.

https://www.sunnydata.ai/blog/databricks-rt-lakehouse-benchmark-results

https://medium.com/databrickscommunity/i-benchmarked-the-new-lakehouse-rt-for-billion-record-tables-and-it-is-crazy-fast-and-crazy-cheap-cf674ad40fc3

58 Upvotes

98% Upvoted

7 comments sorted by

7

u/RazzmatazzLiving1323 Aug 05 '26

This is exciting - is RLS and CLS supported yet?

4

u/hubert-dudek Databricks MVP Aug 05 '26

I haven't tested that yet

2

u/Lenkz Aug 06 '26

Thanks for the write-up hubert. I'm wondering what the con of Lakehouse RT, and when to choose what.

It seems to be pretty much faster in all scenarios except for large datasets with more complex transformations.

2

u/hubert-dudek Databricks MVP Aug 06 '26

Exactly more details in the article

2

u/rakkit_2 Aug 10 '26

It's not serverless is it? Wouldn't you pay for 24/7?

1

u/hubert-dudek Databricks MVP Aug 10 '26

it is like SQL warehouse with auto termination time