Forum Discussion
Writing to a specific warehouse schema using a dataflow gen2
tayloramy pmscorca we implemented the capability of writing to a given schema in Azure Sql, Lakehouse, Warehouse and Fabric Sql quite some time ago already.
As mentioned by miguel you need to ensure that you expand Advanced option when selecting the connector and set "Navigate using full hierarchy" to True.
Once done, on the next stage you'll be able to see the list of schema you can write to
Best regards,
Antoine
Hi, I haven't selected the advanced option to enable the schema navigation (is it documented?).
But also selecting it the result doesn't change:
I cannot specify any schema for the new table.
Here's the link to the documentation about this capability:
Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn
As mentioned by Antoine, once you select this option you'll be able to navigate to the schema of your choice and create or select a table within that specific schema.
The view from your screenshot fundamentally showcases all available warehouses in your workspace, so you need to expand the nodes to be able to see the schemas within them. Fundamentally navigating on the left pane to the schema of your choice.