New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Impersonate database user when running queries #2148
Comments
I think you are running queries with the credentials you set up on your datasources. |
It running queries with onlt root,i want to know how can i run with login user? |
Hi, I am also interested in knowing if this is possible. |
I don't think PyHive (the lib we use to connect to presto) allows for that, does it? |
Actually looks like it may be possible by just using a different connection string as in You'd want to add a configuration Boolean column Then it would be a matter of changing there user here:
|
Would it be considered as a useful feature for Superset, or is it still an open question? |
Yes. Do it! |
@luoruixing this should work now. |
We are just starting to use superset, and I hope I will be able to promote it in our company. Sorry for another comment on a closed request, but do you plan to implement it for other DBMS aswell? I'd like to see this feature for postgres, so that we can leverage features like access rights on tables, row and column level security or policies. It would be even nicer, if something like "set role" would work. |
what SQLAlchemy URI have you guys used for presto to Impersonate the logged on user.
From Presto side: |
The superset start with root and login with user abc
When I query a sql in sqllab (SQLAlchemy is presto),it run with root in presto,How to run with abc??
The text was updated successfully, but these errors were encountered: