In warehouses, we can create custom schema I.e. other than the default "dbo". Good feature.
HOWEVER, in Dataflow Gen2, while choosing a destination, we don't get a choice to select a particular schema in Warehouse and the data gets sinked to the default "dbo" schema.
- Is my observation correct ? Am I missing something here ?
- Any good approaches to achieve sinking yo custom schema of Warehouse?