Hi everyone,

We have two synapse workspaces under one subscription, workspace A and workspace B. Workspace A is act as a centralized data warehouse, and workspace B is created mainly for a specific country’s users to query data from database view in workspace A and work on their specific needs.

The objective are:

-To remain a single source of truth, using one source from workspace A

-To separate resources between workspace A user and workspace B user

-Workspace B user can only query workspace A database view

Is it possible to query the data from database view in workspace A without Copy the data to workspace B? Or what is the best practice to achieve the above.

Best regards,

Chang

​Hi everyone, We have two synapse workspaces under one subscription, workspace A and workspace B. Workspace A is act as a centralized data warehouse, and workspace B is created mainly for a specific country’s users to query data from database view in workspace A and work on their specific needs. The objective are:-To remain a single source of truth, using one source from workspace A-To separate resources between workspace A user and workspace B user-Workspace B user can only query workspace A database view Is it possible to query the data from database view in workspace A without Copy the data to workspace B? Or what is the best practice to achieve the above. Best regards,Chang  Read More

​