I need assistance with writing API/Python code to manage a Databricks workspace permissions database(unity catalog). The task involves obtaining a list of workspace details from the account console, which includes various details like Workspace name, Id, user Permission Type, Service principal permissions and their list for the workspaces etc. I'm looking for efficient methods for data insertion, updating, and querying within this database. Any advice or code examples relevant to this context would be greatly appreciated.
Thanks,