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
Today, and what the original idea shared was tracking, you are able to use existing items (like databases) and schemas to navigate through them and create new tables within them. You can define the names of the new tables after picking the schema like in the example below where I first created a new schema (named schema1) inside the Warehouse experience and then through the data destination experience I get a message that a new table will be created in this schema:
In other words, there is no input box for schema. Instead, you need to select the specific schema from the navigation tree on the left as shown in the screenshot above.
If perhaps this is about having Dataflow create a new warehouse or a new schema, those are valid suggestions and we welcome such suggestions in the Fabric Ideas portal.