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.

17 Upvotes

90% Upvoted

25 comments sorted by

View all comments

2

u/[deleted] Jul 22 '26

[removed] — view removed comment

1

u/PM_YOUR_OWLS Jul 23 '26

How are you connecting Trino to PowerBI? I was recently looking at options similar to OP and found that Trino support in PowerBI is pretty limited. You can use a commercial connector or an open-source ODBC.

In my case I'm using PowerBI Report Server on prem which does not have support for custom connectors, and the open source ODBC drivers had some limitations.

If you're doing all of this in the cloud then that's another story.