Hello,
Is it better to use parquet files rather than azure sql server?
Looking at the system already in-place, In synapse pipelines, we pull data from on-prem sql server into parquet files and then we query the parquet files...
My question is:
Why not use Azure sql server to hold the data rather than parquet files?
Our goal is to provide reports in power BI.
I think it is easier to query Azure sql server rather than parquet files?...
What are your thoughts please?
Thank you