Hey ck_one that's a hard question to answer and not get into "benchmarketing" territory.
My suggestion is to try both under your own workloads and see the difference. Trino is also used by products like Athena (AWS) and Galaxy (Starburst) so if you want to play around and see how Trino performs without spending too much time on setting up clusters on your own, you can try these great products.
Having said that, I'd like to add that building a performant distributed query engine is just hard. Trino has been in development for ten years and used by major companies in very demanding environments, these environments is where the technology has been defined and makes it what it is today and it is a proof of its performance and stability.
(edited to add an important disclaimer that I work at Starburst)
Also with Iceberg or Delta Lake and Trino you can basically run a full lakehouse architecture on open source and places like Bloomberg, Goldman Sachs and many others do just that.
Not sure if those are comparable 1:1. Do you mean you have a datalake that you are using snowflake to query using 'external tables' that you want to replace with trino ?
Yes ... Starburst Enterprise, which is a commercial distribution of Trino, can in fact also query Snowflake, but also Delta Lake and many many other systems at the same time.
My suggestion is to try both under your own workloads and see the difference. Trino is also used by products like Athena (AWS) and Galaxy (Starburst) so if you want to play around and see how Trino performs without spending too much time on setting up clusters on your own, you can try these great products.
Having said that, I'd like to add that building a performant distributed query engine is just hard. Trino has been in development for ten years and used by major companies in very demanding environments, these environments is where the technology has been defined and makes it what it is today and it is a proof of its performance and stability.
(edited to add an important disclaimer that I work at Starburst)