Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,988 questions
Synapse data warehouse and use
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 15%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anshal
2,251
Reputation points
Hi friends, can we build a data mart kind of architecture for multiple domains in Synapse? How to built data marts for specific business entities in Synapse?
{count} votes
-
Nandan Hegde 32,416 Reputation points MVP2024-07-23T12:41:41.53+00:00 Couple of queries before we go on with Marts aspects :
- what would be the use cases/downstreams of marts? - because Synapse dedicated pool is an OLAP system and has concurrency limitations
- What is the size of the data you are dealing with?
And when you say synapse, do you mean synapse eco system or synapse pools?
-
Anshal 2,251 Reputation points
2024-07-23T14:13:15.97+00:00 Thank you.The use cases typically is that there are different departments or business units such as Finance, Marketing etc and each data mart addressees that department/business unit. Please guide me on both Synapse pools as well as Synapse environment scenerios.
-
Anshal 2,251 Reputation points
2024-07-24T11:41:53.9533333+00:00 Could anyone please help
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,116 Reputation points Microsoft Employee2024-08-05T19:13:38.6666667+00:00 Hello
You can create data marts for individual business units within an organization to implement robust data security regimes. This allows users to access only the data marts relevant to them.
reference documents:
Sign in to comment
Sign in to answer