Hello Team, I hope to find you in good health. I have been working on an implementation where we are providing permissions to different schemas through user roles. We encountered a scenario as described below:
1. A new schema was created in Redshift database. We have an existing database connection for this in Superset. New Schemas in Database : [cid:image001.png@01D9C575.8B6492D0] Existing DB Connection in Superset[cid:image002.png@01D9C575.8B6492D0] 1. We tried granting schema_access permission for this new schema by trying to add it in permission list for an existing group. The schema name does not come up in this list. List does not show testing_superset2 schema: [cid:image003.png@01D9C575.DB37E820] 1. We are able to query same schema through sqllab using an admin role. But currently unable to set permission on the schema's access as it does not show up. Schema and table accessible through SQLLab: [cid:image004.png@01D9C575.DB37E820] Any Help in understanding this scenario and resolving it will help. Regards, Tejas Modi Senior Consultant | ConvergeHEALTH - Expert Services Core Industry Solutions | Core Business Operations Deloitte Consulting USI Pvt. Ltd. tm...@deloitte.com<mailto:tm...@deloitte.com> | www.deloitte.com<http://www.deloitte.com/> Please consider the environment before printing This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and any disclosure, copying, or distribution of this message, or the taking of any action based on it, by you is strictly prohibited. Deloitte refers to a Deloitte member firm, one of its related entities, or Deloitte Touche Tohmatsu Limited ("DTTL"). Each Deloitte member firm is a separate legal entity and a member of DTTL. DTTL does not provide services to clients. Please see www.deloitte.com/about to learn more. v.E.1