topic Re: Synapse dedicated SQL pool in Synapse in Data Warehouse

Synapse dedicated SQL pool in Synapse

pmscorca — Fri, 17 May 2024 07:33:00 GMT

Hi,

is it right that does Fabric not have any dedicated SQL pool features?

Re: Synapse dedicated SQL pool in Synapse

Anonymous — Fri, 17 May 2024 08:00:09 GMT

Hi pmscorca ,

Thanks for using Fabric Community.
Fabric doesn't directly map to the concept of dedicated SQL pools found in Azure Synapse Analytics.

Here's a breakdown of the key differences:

Storage: Fabric uses a separate storage layer called OneLake, whereas Synapse relies on Azure Data Lake Storage Gen 2 (ADLSG2) for dedicated SQL pools.
Compute: Fabric utilizes the Polaris engine for automatic scaling, while Synapse offers dedicated SQL pool options with pre-defined configurations (DWUs).
Focus: Fabric targets a broader data warehousing approach with features like self-service analytics and workload management. Synapse, with its dedicated SQL pools, caters more to traditional SQL workloads.

However, there is some integration between the two. Fabric's data warehouse component offers functionalities similar to Synapse dedicated pools. You can migrate your existing pools to Fabric, though there might be a need for adjustments due to the architectural differences.

Please refer below link to get some detail understanding of Fabric -
Microsoft Fabric, explained for existing Synapse users | Microsoft Fabric Blog | Microsoft Fabric
Azure Synapse Analytics versus Microsoft Fabric: A Side by Side Comparison (endjin.com)

Hope this is helpful. Do let me know incase of further queries.

Re: Synapse dedicated SQL pool in Synapse

Anonymous — Mon, 20 May 2024 10:32:48 GMT

Hi pmscorca ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Re: Synapse dedicated SQL pool in Synapse

Anonymous — Tue, 21 May 2024 10:36:57 GMT