Why would I migrate from Synapse Serverless to Fabric?
We currently run a Synapse based stack where we pull data in with ADF pipelines, store the data as parquet files in Datalake Gen 2, and then expose those parquet files as external tables in Synapse Serverless. We also create our serving layers (FACTs and DIMs) in Synapse using CETAS.
Everything is lake based and the costs are low.
Overall our data volumes aren't huge (we have about 1TB stored in the lake so far). But because you pay for TB of data scanned ($5 per TB scanned) and we rarely scan over all data at once (most of the 1 TB is daily snapshot history of different data sources, which we only use for rare usecases), our monthly costs for our datalake setup are give or take ~100 EUR per month.
This is with daily refreshes of data from 5+ systems, several FACTs and DIMs being created and refreshed daily, and about 30+ PBI reports consuming data from this setup.
I really like pay per query models as they're so much cheaper than paying for infrastructure or resource based 'serverless' models like Snowflake / Databricks (in my experience).
AWS has Athena. Google has BigQuery. Azure has Synapse Serverless. All have the same pricing: $5 per TB scanned.
But Microsoft seems to be pushing people away from Synapse and Fabric doesn't seem to support this type of payment model. Instead they offer Fabric at a capacity based rate starting at an F2 SKU of ~$300 per month.
I'm assuming this smaller capacity will have worse performance for larger queries and we'd be paying 3x as much. I'm struggling to understand why I would migrate to Fabric?