Forum Discussion

XhevahirMehalla's avatar
XhevahirMehalla
Icon for Helper IV rankHelper IV
24 days ago
Solved

Decision on using Fabric SQL or Fabric Warehouse

Hello,   We are trying to migrate from synapse to fabric. Current solution is: source data= oracle OCI use Synapse Pipelines to copy oracle data to ADLS Gen 2. Synapse Dataflow to transform and...
data hub
  • v-sathmakuri's avatar
    v-sathmakuri
    24 days ago

    Hi XhevahirMehalla​ ,

    Thank you for reaching out to fabric community.

    • Gold layer: Prefer Fabric Warehouse for your 6+ TB data warehouse and Power BI reporting workloads.
    • Bronze/Silver layers: Use Fabric Lakehouse for raw data storage and large-scale transformations.
    • Fabric SQL database: Best suited for transactional workloads not as the default choice for an enterprise analytical warehouse.
    • Azure SQL Hyperscale: Supports databases up to 128 TB and offers independent compute scaling, but it is an Azure SQL Database service tier not a Fabric SQL database feature.

    Recommendation: Use Fabric Warehouse for Gold and validate performance and capacity costs with a proof of concept before migration.

    Thanks!!

v-sathmakuri's avatar
v-sathmakuri
Icon for Community Support rankCommunity Support
24 days ago

Hi XhevahirMehalla​ ,

Thank you for reaching out to fabric community.

  • Gold layer: Prefer Fabric Warehouse for your 6+ TB data warehouse and Power BI reporting workloads.
  • Bronze/Silver layers: Use Fabric Lakehouse for raw data storage and large-scale transformations.
  • Fabric SQL database: Best suited for transactional workloads not as the default choice for an enterprise analytical warehouse.
  • Azure SQL Hyperscale: Supports databases up to 128 TB and offers independent compute scaling, but it is an Azure SQL Database service tier not a Fabric SQL database feature.

Recommendation: Use Fabric Warehouse for Gold and validate performance and capacity costs with a proof of concept before migration.

Thanks!!