Using Synapse serverless SQL pools
Serverless SQL pools are an offering that was introduced with the Synapse workspace. It is a SQL engine that works in a distributed manner in the background. It can therefore offer a high fault tolerance even when you run it against bigger volumes of data in your data lake.
The serverless SQL engine comes in handy for different types of workloads:
- Ad hoc data analysis using SQL
- Transforming, cleansing, and preparing your data in the data lake using SQL
- Virtual data warehousing on multiple files and folders without transporting your data any further from your data lake
As the name suggests, the serverless SQL pool does not cause upfront resource provisioning in your Synapse workspace. It is charged on a volume basis (TB queried per month) based on competitive rates (see the Further reading, Synapse pricing section). This means that you will not generate any costs when you aren't running queries on the serverless SQL pool...
