Question: I've reviewed the Microsoft Fabric roadmap but haven't found any mention of Dataflow Gen2 support for ingesting data into non-'dbo' schemas in Fabric Warehouse.
Does anyone know if there are plans to allow direct ingestion into custom schemas for both new and existing tables, without requiring a staging step in dbo?
I've explored the staging workaround, but I’d prefer a solution that avoids data duplication and allows direct schema mapping.
Any insights would be appreciated!
1 Comment
- Alaahady
Helper II
As a user actively transitioning to Microsoft Fabric and leveraging its enhanced capabilities for big data analytics, I strongly support enabling custom (non-dbo) schema support in Dataflow Gen2. This feature is essential for maintaining organized, scalable, and enterprise-grade data architectures—especially in environments where schema separation is critical for governance, performance, and collaboration across teams. Avoiding the need for staging in dbo not only reduces duplication but also aligns with best practices in data warehousing. Adding this capability will significantly improve adoption and usability of Fabric, reinforcing Microsoft’s strategy to empower data professionals with flexible, modern tools. Looking forward to seeing this enhancement prioritized!
Recent ideas
Add Automated Pre-Upgrade Compatibility Assessment for Fabric Spark Runtimes
Microsoft Fabric should provide an automated compatibility assessment before a workspace, Environment, notebook, or Spark Job Definition is upgraded to a newer Fabric Runtime. Spark runtime upgra...mourakshit6 minutes agoNew MemberNew1View0likes0CommentsSupport Creator-Independent Managed Identity and Ownership Transfer for Fabric Operations Agents
Microsoft Fabric Operations Agents should support an enterprise identity and ownership model that is independent of the individual user who originally created the agent. Today, an Operations Agent r...mourakshit7 minutes agoNew MemberNew1View0likes0CommentsAdd Centralized Health, Freshness Monitoring, and Alerts for OneLake Shortcuts
Microsoft Fabric should provide a centralized health-monitoring experience for OneLake Shortcuts across workspaces and data sources. As organizations adopt OneLake Shortcuts at enterprise scale, hun...mourakshit10 minutes agoNew MemberNew2Views0likes0CommentsAdd Schema Compatibility Policies and Breaking-Change Detection to Fabric Event Schema Registry
Fabric Event Schema Registry should support configurable schema compatibility policies so teams can safely evolve event contracts without breaking downstream Eventstreams, Eventhouse ingestion, appli...mourakshit13 minutes agoNew MemberNew2Views0likes0CommentsAdd Dry-Run Simulation and Historical Event Replay for Fabric Activator Rules
Fabric Activator should provide a dry-run simulation mode that allows developers to test rules against historical or sample event data without executing real downstream actions. Activator rules can ...mourakshit15 minutes agoNew MemberNew2Views0likes0Comments