is Synapse Analytics SQL cost effective to store deleted record in dataverse?

Question

I'm newbie to use azure services. I'm using power apps portal for my personal business case were it stores all the business data into dataverse which now holds huge amount of stale data which is not needed. So i need to archive those data. doing some research i got to know about synapse analytics link in power apps which will help us to store the dataverse data into azure synapse sql pool. im pretty confused here. if i can transform only my deleting records into that azure synapse sql pool is possible? or even if i replicate all my dataverse table into azure synapse analytics sql pool will cost more than what it stored at dataverse? basically what im asking is storing data in dataverse is costly or azure synapse sql pool is costly? or suggest me any ways do help me to archive my stale data in dataverse?

Answer 1

Hello @Charles Michel Beskie (For Azure) ,
Thanks for the question and using MS Q&A platform.

So, as I understand, you are asking whether Synapse dedicated SQL pool is a good place to store archive data, compared to Dataverse.

For archive data you will never look at again, neither of these is the right option. Instead, you should use Synapse to copy the data into an Azure Storage Account. Either blob storage or Azure Data Lake Gen2. Then you can shift those into cold storage mode, which is MUCH less expensive. Your Synapse Workspace can have integrated storage.

I do not use Dataverse, so I do not know whether Dataverse has archive features. Something to look into.

If you expect to use this data again, there is a spectrum of possibilities between the above, and Dedicated SQL Pool. This includes serverless, External tables, and more.

Dedicated SQL Pool is a cluster of computers meant for doing analysis or transformation or other SQL tasks, using it expressly for storage is not a good use of resources. Store only what you expect to need in the Dedicated Pool. You can pause the pool to lower the cost.

From what I see in power apps pricing (1 GB for $10 month on pay-as-you-go plan) and synapse-analytics pricing (Data Storage at $23 per TB/month), Synapse warehousing is much cheaper, but dedicated pool uptime is more expensive. Synapse Serverless is 5$ per TB.

Please do let me if you have any queries.

Thanks
Martin

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators