Community Conundrum 28: News Engagement is live! Read More

Connection to Presto.

Dataiker
Dataiker
Connection to Presto.
Hi,

I have several data sources that I would like to consolidate via Presto and use Dataiku to connect to it.

How can I connect to Presto?

Thanks,
Buelent
2 Replies
Dataiker
Dataiker
Hi,

DSS does not have support for Presto at the moment.

You can try installing the JDBC driver for Presto as explained here: https://doc.dataiku.com/dss/latest/installation/jdbc.html and then use the "Other databases (JDBC)" dataset, but this generally only provides limited read-only support, and may not work.
Level 1
Thank you.

Prestogres (https://github.com/treasure-data/prestogres/) might be better choice at this stage. It is based on PLPython and it does replicate the Presto dataset into PostgreSQL tables and uses UDFs to select directly from Presto. The setup looks straightforward as well.

I will try it out and see how it goes. We might be able to remap some of the column definitions in PostgreSQL.

It would be great if Presto can be on the Roadmap. It is a "distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources".

Thanks,
Buelent
0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS