How to optimise the cost in using Synapse Azure

When you are using Azure Synapse for your data analytics. You may be concerned on the cost. There are a lot of general cost optimisation where you are using cloud resources though, I will talk about Synapse specifically today.

1. Choose the appropriate Synapse workspace tier

Imagine if you buy Lamborghini to go to e-mart everyday. Choose the right size of the resource to serve your task is first thing to optimise your cost.

Azure Synapse provides different tiers and pricing models. Choose the most suitable tier based on your needs and usage patterns:

• Serverless: Pay-per-query model; ideal for ad-hoc querying and teams that don’t need dedicated resources.
• - Dedicated: Pay for the resources you reserve; suited for organizations with predictable workloads and performance requirements.

2. Optimize data movement

Minimise data movement between different services, regions, and storage accounts to reduce network costs. Consider every movement charge you so you need to store your data close to the Synapse workspace and use managed private endpoints to access data securely and efficiently.

If you already have paid dedicated pool, you can use cache so synapse pool won’t go back to the storage to retrieve the data again…