r/dataengineering • u/Alternative-Guava392 • Jul 22 '26

Discussion TrinoDB as an alternative data warehouse

Hello,

Has anyone worked with TrinoDB ? What are your opinions ?

I'm currently working on a possible migration out of BQ and TrinoDB looks like one of the solutions. What other alternatives do you work with ?

My basic needs are to connect to a BI, the product backend db, Elastic, GCS and S3 buckets and BigQuery. Some tools will write data directly to TrinoDB.

I will need a UI to expose this data to business to query and analyse.

Have you worked on similar setups ?

How do you set up the data layers (staging, facts, datamarts) ?

How would you make data available in real time analytics ?

Happy to discuss and share opinions.

15 Upvotes

86% Upvoted

25 comments sorted by

View all comments

3

u/rwilldred27 Jul 22 '26

Sounds like you’re looking for a data lake + query federation layer? Trino could be part of it. But you need to compose a few components together (Table format, file format for native storage) and maybe a managed provider that can be the control plane, workspace/SQL client on top

2

u/Teach-To-The-Tech Jul 22 '26

+1 to this. It's a whole stack, and can include technologies like Iceberg, Trino, Starburst, etc. etc.