logoalt Hacker News

gonzalohm • yesterday at 5:11 PM • 2 replies • view on HN

How does Snowflake use that information? You still need to pick the warehouse. It would be cool if there was an "elastic warehouse" where heavier queries are routed to bigger Warehouses, but that's not the case


Replies

roboben • yesterday at 6:55 PM

[Author] Basically what we are doing with the help of Trino: a distributed query engine which can use as many resources as the query needs dynamically.

lokar • yesterday at 6:39 PM

There is an elastic option, I think . Also, even with a specific warehouse, not every query uses every node in the warehouse.

➕ show 1 reply