How to migrate Dedicatel SQL Pool (DW) to Serveless Synapse?

Question

I have Azure Datawarehouse which has fixed pricing tier DW100. Usage is small and assuming that Serverless can be cheaper.

A) How do get information how much data processing have been occururing in last month?
B) How to do migration to Serverless?

Answer 1

Hello @Kenny ,

Thank for the ask and using the forum .

1. I think you can use the DWU used metrics to get more info on the usages . Please do read about this here
2. I need to understand as to what do you mean by migration here . Serverless synapse somes with the analytics workspace is used to query data in the lake , I am sure that the dedicated SQL is far rich then serverless , You can read about this more here .

Thanks
Himanshu

Answer 2

1. Metrics of DWU does not give me "TB of data processed" of month.
2. I'm using Dedicated DW for Power BI usage. Data is processed with Data Factory and databricks and other tools. Is it possible to replace dedicated dw with serverless? If yes, How to migrate schema and data?