Forum Discussion

KimBeck's avatar
KimBeck
Regular Visitor
2 years ago
Solved

Best practice for using meta/config "table" for controlling loads?

For years I have been using a e.g. meta.LoadConfig table for controlling incremental/fullload and other options for controlling data load from sources to the classic Staging->DWH architecture. This h...
pipelines
  • KimBeck's avatar
    KimBeck
    2 years ago

    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.

     

     

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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.


Thanks

KimBeck's avatar
KimBeck
Regular Visitor
2 years ago

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.