Synapse Data Warehouse – in MS Fabric

Synapse Data Warehouse

The Synapse Data Warehouse is very familiar to long standing data professionals, because it derives so much of its functionality from Microsoft SQL server, which has been the backbone of organizational data since the 1990s.

While it is on the cloud, while many older SQL databases remain “On premises”, it is so similar to SQL that you can often import your database structure, tables, relationships, and queries often directly from SQL server.  You can also bring across complex business logic from T-SQL transactional statements.

So for a business this is good news, representing a relatively straightforward way to get your existing data and business logic, into the cloud, into Microsoft Fabric, and ready for reporting and AI with the minimum of difficulty.

Main Functions of a Data Warehouse

If you’re doing anything with data already there’s a strong chance you’ve already got some Data Warehousing going on which can relatively easily be re-used in a Fabric Synapse Data Warehouse, to:

  1. Compile large tables of transactional data.
  2. Import and validate that data.
  3. Aggregate these tables up, for example by day, by store, or by product category, so that when your reporting runs on that data, it can deliver an answer quickly.

Retained Skills and Code with Synapse Data Warehouse

The Synapse Data Warehouse is an important element in Microsoft Fabric and allows teams with long standing SQL Server expertise to easily become productive in Microsoft Fabric, and use their skills and Transact-SQL code to begin their jouney into cloud-based Big Data, Business Intelligence and AI.