Can redash use real user to query Presto?

[payt0nc]

Issue Summary

Can redash use different users to query Presto?

We have nearly a hundred users sharing a redash to query our Presto. From Presto configuration, it's configured that only accepted two queries / user. I don't think enlarged presto limit is good solution because the instances of presto are limited and accepted more queries per user will let other users(we have other access like Tableau) slow down.

Will you consider that to use real user account in redash to query Presto instead of sharing redash?

Technical details:

• Redash Version: 4.0.1.b4038
• Browser/OS: Ubuntu 14.04.5
• How did you install Redash: AWS EC2 Image @ 0.12.0.b2449, and keep updated to latest version by version.
• Presto Version: 0.203

Thanks.

[nasmithan]

Are you using any HTTPBasicAuth for connecting to presto? Using any certs or anything?

[payt0nc]

We did not use any auth on Presto. In other words, anyone can be connected into our presto if she/he get the connection string and given any username.(But she/he must be in our intranet first).

[nasmithan]

We are able to get it working on our setup. We use nginx for security to handle users, and we actually use a password as well. Our presto.py file has the following connection details (and added password to the schema) and it works:

connection = presto.connect(
    host=self.configuration.get('host', ''),
    protocol='https',
    port=self.configuration.get('port', 8080),
    username=self.configuration.get('username', 'redash'),
    password=self.configuration.get('password', 'redash'),
    catalog=self.configuration.get('catalog', 'hive'),
    schema=self.configuration.get('schema', 'default'))

[Ralnoc]

I have opened PR #3723 that resolves this issue.

• Username: It uses the configured field for username over all else, then uses the email address to extract the username based on the left side of the @ symbol in the email address and finally, if all of that is missing, defaults to redash.
• Password: is pulled from a new password field in the configuration page for Presto
• Source Identifier: It changes the source identifier for pyhive so that instead of reporting itself as pyhive to Presto, it declares itself as redash.

Just waiting for them to review, approve and merge it.

[payt0nc]

Awesome. Thank you so much for creating this feature.🙇🏼‍♂️