Visualizing MongoDB and Pinot Data Using Trino

[@purvishjariwala2309]

Thanks, Biran and Srini. I was trying to understand the purpose of Trino and this video cleared my all doubts. Maybe, I will write a blog with some other examples and publish it.

[@brianolsen87]

Thanks Purvish! That would be awesome!

[@philipb.5746]

Could you tell me where in the configuration of trino the Host für the URL will be set?

[@brianolsen87]

The url for Mongo is set at 38:14, the url for Pinot is set at 39:05, and the Trino URL will be the IP address or DNS name that points to the coordinator node (in this video it was ec2-34-204-197-108.compute-1.amazonaws.com), and by default the port used is 8080. Therefore the URL to talk to Trino's web ui was: ec2-34-204-197-108.compute-1.amazonaws.com:8080 . Which has long since been torn down :) You can also configure a different port other than 8080 in Trino's etc/config.properties file. See more in the docs: trino.io/docs/current/installation/deployment.html#config-properties

[@h3651551]

Hi, Does trino support PowerBI as client? I mean trino only offer JDBC driver, but PowerBI seems only support ODBC

[@brianolsen87]

Great question Katzie. There's actually a thread going on about that in the Trino slack in the last few days trinodb.slack.com/archives/CP1MUNEUX/p1618277265248300. The only ODBC driver that I am aware of for Trino is the commercial one my company Starburst offers (docs.starburst.io/data-consumer/clients/odbc.html). This does require a license though. There has been some talk among different folks to write an open source one (including in the thread that I linked above) but nothing has materialized yet. I recommend joining the Trino slack so you can better keep tabs on these developments. trino.io/slack.html