Hi Team We have data 3 months data in Aurora and more than 3 months data in redshift, we wanted to use StarRocks in this scenario, is it better than Trino considering we dont want to move our data sources.

Yep, you got it https://celerdata.com/trino-alternatives-comparisons

But can we connect using JDBC protocol and get the good performance considering external data sources?

Yes, we support multiple external data sources, including jdbc https://docs.starrocks.io/docs/data_source/catalog/jdbc_catalog/

Could you please highlight on it’s performance than Trino when using JDBC Protocol?

What exactly are you trying to connect to? In general we are usually about 2-3X faster.

I want to use StarRocks as federation tool for external databases like Aurora and Redshift, I wanted to know how is the performance in this scenario compared to Trino?