User Profile
LorenzoBonati
Microsoft Employee
Joined 1 year ago
User Widgets
Contributions
Automating SQL Permissions Deployment in Microsoft Fabric Data Warehouse
Fabric Deployment Pipelines and Git integration currently don’t transfer SQL object-level permissions when moving a Warehouse from Dev to Prod. After seeing this come up in some customer cases, I put together two small scripts that help you identify permissions in your Dev environment and export them so you can reapply them in Prod. Sharing them here so others can benefit as well.Add Delete Button in the UI for users that face orphaned SQL Endpoint
During Lakehouse deletion operations in Microsoft Fabric, users may observe that the associated SQL Endpoint and Semantic Model are not automatically removed. These orphaned artifacts may cause downstream deployment errors or stale resource references. There is one available API to remove it, but it is not very user friendly and also requires admin rights so developers cannot do this on their own. It is mentioned here: Solved: Can't delete orphaned lakehouse SQL analytics endo... - Microsoft Fabric Community The idea is to make this option available in the UI or at least provide more user friendly ways to do it.
