I have a Warehouse with multiple user schemas. I wish to have Dataflow Gen2 Destinations create/populate tables in those schema. But in the dialog to enter the table name when setting up the Destination, if I enter something such as MySchema.MyTable (where MySchema ALREADY EXISTS in the warehouse as a schema) I do NOT get MyTable located in MySchema.
What I get is an object in the dbo schema named [MySchama.MyTable].
Yes, I finally figured out that you have to go BACK one screen and expand the Advanced options and select True for Full Hierarcy Navigation, and THEN you can target a specific schema. But HONSTLY, who figured that out FIRST TIME AROUND?
Those of us that have been working SQL databases for years have been referring to objects with two-part nomenclature (<schema name>.<table name>) so to have THIS outcome instead of what I expected is a huge disappointment.
PLEASE MAKE THIS EASIER TO USE.
Take a page from the Azure Data Factory folks where you have TWO boxes displayed at once: one for schema name and one for table name. THAT is easy to understand.
on:
CI/CD support for Notebook Resources folder
tbindas-msft
on:
Add Object, Workspace and User details to Capacity...
on:
Variable Library: Shortcuts with variable value th...