Member-only story
Best Practices when working with Azure Synapse
How to work efficiently with serverless SQL-Pools
If you are in the Microsoft Azure Cloud and want to run big data analytics there and run a Data Warehouse, you might well choose Synapse Analytics here.
What is Azure Synapse Analytics?
Azure Synapse Analytics is an analytics service that combines data integration, data warehousing, and Big Data analytics. You can either use the serverless or dedicated option. Azure Synapse brings these worlds together in a unified interface to capture, explore, prepare, transform, manage, and deliver data for out-of-the-box business intelligence and machine learning applications [1]. If you are interested in how it compares to other solutions, this article might be interesting for you.
What are the Best Practices?
When working with SaaS Data Warehouses, you should also always think about the costs. The cloud can save a lot of money, but you should also follow best practices, otherwise antipatterns may lead to additional or unnecessary costs.
Therefore, here are some tips that I have found useful during my work with Synpase and that Microsoft also recommends here [2]:
- Collect all of your client applications…
