Connection to Presto.

Solved!
UserBird
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
1 Solution
Clรฉment_Stenac
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.

View solution in original post

2 Replies
Clรฉment_Stenac
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.
bzeyben
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

?
Labels (2)
A banner prompting to get Dataiku