Connect from Denodo¶

If you do not have the Denodo subscription bundle Enterprise Plus you can also deploy the Denodo Lakehouse Accelerator and connect to it from Denodo, using a standard JDBC data source, not the Denodo Lakehouse Accelerator data source, but without benefiting from Denodo’s optimization capabilities.

You have to fill in all the required fields:

• Name

• Database adapter: PrestoDB

• Driver class path: presto-0.1x

• Driver class: com.facebook.presto.jdbc.PrestoDriver

• Database URI: jdbc:presto://presto-denodo:8443/hive/default?SSL=true&protocols=http11

• Login: presto

• Password: pr3st%

Important

Requirements to connect from Denodo JDBC data source to Denodo Lakehouse Accelerator:

Note that if the certificate used by the Denodo Lakehouse Accelerator is signed by a private authority, or it is self-signed, you have to import the Denodo Lakehouse Accelerator certificate into the Denodo server truststore.

The certs/certificate.crt is distributed for testing purposes ONLY. This certificate accepts presto-denodo as the Denodo Lakehouse Accelerator hostname. In this case, you have to add an entry in the hosts file where the Denodo server is running, with presto-denodo and the IP that appears as the EXTERNAL-IP of the Presto service.

Kubernetes services status¶

Ping External IP¶

hosts file¶

JDBC data source to Denodo Lakehouse Accelerator¶

Once the data source is configured, click Create base View to explore the Denodo Lakehouse Accelerator schemas with their tables and their columns.

Denodo Lakehouse Accelerator tables¶

You can now run any query you want on your datasets.

Query results in Denodo¶