Forum Discussion
Best practice for using meta/config "table" for controlling loads?
I found a way to work with a meta table in my Warehouse in my warehouse Workspace from a Bronze Workspace.
I managed to do a lookup to the table by using "Workspace" (not "External"), selecting Warehouse and then specifying the WarehouseID from the URL of my Workspace containing my Warehouse. Then I had to add the SQL Endpoint parameter also. Then I could access the config.meta table accross Workspaces.
Thanks for the input.
yes, I am looking for a way to port my existing dataflow control knowledge to Fabric conditions.
Right now, I want to build a Bronze LH -> Silver LH -> Gold WH architecture.
I think that currently, the best solution would be to have a "config" schema in the Gold WH, then I can update the meta/config/control tables in SSMS like I am used to.
The connect from Data Factory to this table and retrive the metadata.
The proposed solutions are interesting, they do however suggest provisioning a Azure SQL Database for the meta data.
v-cboorla-msftMicrosoft Employee
Hi KimBeck
Following up on your query to see if you've reached a resolution. And was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
ThanksI found a way to work with a meta table in my Warehouse in my warehouse Workspace from a Bronze Workspace.
I managed to do a lookup to the table by using "Workspace" (not "External"), selecting Warehouse and then specifying the WarehouseID from the URL of my Workspace containing my Warehouse. Then I had to add the SQL Endpoint parameter also. Then I could access the config.meta table accross Workspaces.