rumbin commented on pull request #14393: URL: https://github.com/apache/superset/pull/14393#issuecomment-841036220
> I'm writing a SIP (Superset Improvement Proposal) about datasets, proposing the creation of a separate model for tables and datasets, instead of having a single `SqlaTable` model. It's nice to see that some of the ideas I want to propose are needed. :) Definitely! In my understanding the Presto catalogs seem to be somewhat similar to Snowflake's multiple databases in a single Snowflake account. And this is exactly our use case: Ideally, we would simply define the Snowflake connection once, have the connection mutator adjust to the user's role and provide access to all visible databases of the Snowflake account this way. Since a user can join tables from multiple Snowflake DBs, it is not quite useful to distinguish them on a connection level. This would also have to be reflected in the schema browser in SQLLab, though. Only one of the Snowflake DBs can be browsed here at a time and the user needs to decide which one to use.... I would be grateful if you could include these considerations in your SIP, @betodealmeida. If you like, we can discuss things together and I can contribute my thoughts. -- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
