Hen0k commented on issue #30957: URL: https://github.com/apache/superset/issues/30957#issuecomment-2485050336
I only have a vague idea about what would need to change for this to work. I am not sure about the other details. That was why I skipped them. I have tried look at both approaches you suggested. The second one requires introducing new tools to the architecture. And it will be better if I keep that a last option. I have also enabled Shillelagh and can save public sheets as datasets using sql lab queries. but this only works with public sheets. And the issue with the first approach is, it doesn't work unless the user has access to all databases. With the "Can Write on Database" permission, they will be able to create the connection. But they can't access that database right after they create it. This requires an admin to provide them the access. It would be cleaner, if they could have access to the database since they created it. But I am not sure how that would work. That was why I was trying to use a single database for google sheets. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
