Search code examples
impersonationapache-supersettrino

Superset with Trino Impersonation and LDAP

I have a Trino cluster configured to use LDAP and I want to use Superset to connect to it.

The Trino cluster uses HTTPS with a self signed certificate

I managed to configure Superset to use LDAP, that's not the problem. I also managed to query Trino by having the following configuration:

sqlalchemy URI: trino://myuser:mypassword@trino_server:8443, security extra config: {"connect_args": {"verify": false}}

Now here's the problem: Under the security tab there's a checkbox that says "Impersonate logged in user (Presto, Trino, Hive and GSheets)" . I checked the box, and still the queries I execute run with the user "myuser" which is configured in the sqlalchemy URI, instead of the logged in user.

I'm using Superset version 1.3.2

Does anybody know how to solve this?

Solution

  • just wanted to let you know that I managed to solve this issue.

    The problem was that I put this configuration - {"connect_args": {"verify": false}} in the "SECURE EXTRA" section under the "Security" tab, instead of in the "ENGINE PARAMETERS" section under the "Other" tab.