You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "santoshmallah (via GitHub)" <gi...@apache.org> on 2023/03/08 06:08:00 UTC
[GitHub] [superset] santoshmallah opened a new issue, #23306: How to achieve multitenancy in superset using single instance
santoshmallah opened a new issue, #23306:
URL: https://github.com/apache/superset/issues/23306
How do we have different database connections having separate metadatabase connections per tenant?
Example:-
Tenant-1: Database-1
Tenant-2: Database-2
If user login is of tenant-1
```SQLALCHEMY_DATABASE_URI = 'postgresql+psycopg2:// dbusername:dbpassword@localhost/ Database-1'```
else if user login is of tenant-2
```SQLALCHEMY_DATABASE_URI = 'postgresql+psycopg2:// dbusername:dbpassword@localhost/ Database-2'```
Therefore the user is login and belongs to whichever tenant SQLALCHEMY_DATABASE_URI database connection to be changed to according to that tenant
- browser type and version: Chrom
- superset version: `201`
- python version: `3.8.0`
- node.js version: `16`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] raxit-technosouls commented on issue #23306: How to achieve multitenancy in superset using single instance
Posted by "raxit-technosouls (via GitHub)" <gi...@apache.org>.
raxit-technosouls commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1512849369
I have similar use case, any advise how to handle?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "busyboy77 (via GitHub)" <gi...@apache.org>.
busyboy77 commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1807519480
Vote++
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "busyboy77 (via GitHub)" <gi...@apache.org>.
busyboy77 commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1972596429
We can sponsor this achievement ( with certain conditions ). Please share the way forward. Thank you
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "williamsdb (via GitHub)" <gi...@apache.org>.
williamsdb commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1826820178
Yes, when I first asked I assumed it was possible but it seems not.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1975424135
@busyboy77 this would be a large enough change that people will have myriad security concerns and want to thoroughly review/discuss any architectural/permissions changes. You can submit a [SIP](https://github.com/apache/superset/issues/5602) if you'd like to propose a technical approach for this.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "k31thchan (via GitHub)" <gi...@apache.org>.
k31thchan commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1826763477
I guess it is more like feature request?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "aldipee (via GitHub)" <gi...@apache.org>.
aldipee commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1972402245
Any update on this?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #23306: How to achieve multitenancy in superset using single instance
URL: https://github.com/apache/superset/issues/23306
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "joeyJsonar (via GitHub)" <gi...@apache.org>.
joeyJsonar commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-3259994428
Hello, we will try to give this a crack as this is a very high priority for us.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] How to achieve multitenancy in superset using single instance [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1972406255
No update here, and I'd say it's not likely as a core feature. Closing this since it's not a bug, but a feature request. Typically, if people need multiple tenants, they spin up multiple instances (e.g. in Preset, we call these Workspaces). It is possible to do so, though non-trivial, and again not likely to be a Superset feature in the near future. If anyone is truly interested in implementing this, however, we'd be open to a SIP (Superset Improvement Proposal) and can provide more information on that process if needed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] sslankesh commented on issue #23306: How to achieve multitenancy in superset using single instance
Posted by "sslankesh (via GitHub)" <gi...@apache.org>.
sslankesh commented on issue #23306:
URL: https://github.com/apache/superset/issues/23306#issuecomment-1722861543
I too have similar usecase.
Our problem is we cannot keep data of two clients in single database.
So row level security is out of question for us.
Only option is to have separate database schemas.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org