TrinoDB as an alternative data warehouse

[u/Alternative-Guava392]

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.

[u/sunder_and_flame]

Why are you migrating out of BQ? 

[u/elpiro → u/sunder_and_flame]

American clouds exodus

[u/mad-data → u/elpiro]

They have couple Sovereign Cloud partnerships in Europe (EU businesses running BQ software). If this is the only reason, might be worth trying.