Apache NiFi: How NiFi connect to Presto?

[#1]

Hi All,

I am using ExecuteSQL to connect with Presto. However, my Presto does not have user and ExecuteSQL need Database user.

So, Is there any other way to connect to Presto from Nifi (1.9.0 )? (if no, how to create user from Presto? or how to get/ configure

X-Presto-User 

from presto on docker for example https://hub.docker.com/r/starburstdata/presto/)

Many thanks

[#2]

ExecuteSQL will use Database Connection Pooling Service controller service.

From there you configure a JDBC connection string.

The connection string will depend on the specific jar you will use so in this case Presto

Here is reference on JDBC connection for Presto and that is an external database function and not so much NiFi issue:

https://prestodb.io/docs/current/installation/jdbc.html