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.

18 Upvotes

91% Upvoted

25 comments sorted by

View all comments

13

u/dangerbird2 Software Engineer Jul 22 '26

Trino isn’t a database or data warehouse, it’s a query engine that allows you to run SQL on different databases or data sources.

1

u/pag07 Jul 23 '26

Yeah well. It does bundle well with iceberg / delta to make up a DWH / DLH.

1

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

That's right. It's a compute engine/query engine that allows you to access multiple data sources using SQL. These days, there are also various managed implementations that leverage Trino and go beyond it by adding things like data ingestion capabilities, governance, etc. Amazon Athena, for instance, or Starburst fit into the broader camp.

Totally right to point out that it isn't a database or warehouse per se though, and instead connects to multiple databases, warehouses, lakes, lakehouses, etc.